• October 23, 2006 23 Oct'06

    "Only a DBA can import a file exported by another DBA" error

    I'm getting these errors: "Export file created by EXPORT:V09.02.00 via direct path, IMP-00013: only a DBA can import a file exported by another DBA, IMP-00000: Import terminated unsuccessfully."  Continue Reading

  • October 23, 2006 23 Oct'06

    Test to check query in Toad

    I want to test to make sure that a query is working in Toad. I would like to pull the top 10 rows, but select top 10, column, column, etc. doesn't seem to run.  Continue Reading

  • October 23, 2006 23 Oct'06

    Migrating data to new server without loss

    We use Oracle 9.2.0.4 on SLES 8.1. Now we are planning to change the server to Solaris 10x86 and Oracle 10g. It will be a new, more powerful server. How do I migrate my data from the old server to the new server without loss? Using exp/imp or other ...  Continue Reading

  • October 23, 2006 23 Oct'06

    Problems backing up LOB tables

    I am having problems backing up my large database. Its size is 50GB. It has two tables containing LOBs and other tables that are not posing problems. Whenever my backup gets to the LOB tables, it hangs and comes back with a rollback segment error, ...  Continue Reading

  • October 23, 2006 23 Oct'06

    Migrating with ASM

    How I can migrate a database on Oracle 8i Windows into Oracle 10g with ASM on HP-UX? When I try to use the import the .dmp file creates its own datafiles, it doesn't use the ASM storage!  Continue Reading

  • October 23, 2006 23 Oct'06

    Creating new tablespace in oradata folder

    In my Oracle 10g database installation, the oradata folder is at the same level as that of the Oracle 10g database folder. I have no access to this folder. I have another oradata folder inside the Oracle 10g database folder. I have access to it., ...  Continue Reading

  • October 23, 2006 23 Oct'06

    Recovering system datafile without backup

    How can I recover my system datafile without any backup? I was converting locally to dictionary-managed tablespaces by executing the query exec dbms_space_admin.tablespace_migrate_to_dictionary('ts1'); after some time when I started my db I got the ...  Continue Reading

  • October 23, 2006 23 Oct'06

    Clone database with exp/imp on Linux

    Is it possible to clone an Oracle 10g database from Linux (R3 update4) server to IBM Blade Server under Linux AS4 with exp/imp?  Continue Reading

  • October 23, 2006 23 Oct'06

    ORA-02248 error while trying to import

    I want to migrate from Oracle 8.05 to Oracle 9i. I exported the database in 8.05 and then tried to import it in Oracle 9i. I am getting the following error: "ORA-02248." Plesae help me solve my problem.  Continue Reading

  • October 23, 2006 23 Oct'06

    Switching database to archive log mode

    I have a database that is not in archive log mode that is going to be changed to archive log mode. I'm trying to plan how often I'll have to back up the archived log files and how much space I will need to hold them. How can I tell how many log ...  Continue Reading

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close