Q: Oracle 8 database migration ?
Date: Sat, 10 Jul 1999 11:53:20 -0400
Message-ID: <37876C70.929E59F0_at_bellsouth.net>
I want to migrate the whole database from a remote Oracle 8 server to my Oracle 8 server.
Now I got two sets of data:
- The whole remote c:\orant\database directory, including ctl1trn.ora, ctl2trn.ora, indx1trn.ora, inittrn.ora, logtrn1.ora, logtrn2.ora, oms1trn.ora, rbs1trn.ora, sys1trn.ora, tls1trn.ora, usr1trn.ora, etc. The whole directory is about 1.5G.
- 990705.dmp file, about 80M. This is an exported file from the remote server. This also comes with a 990705.log file, telling me all the exported tables and their owners.
For data set 2, I tried to use the imp80 command to import all tables by
OMS_OWNER from the 990705.dmp file.
My command line is like this:
IMP80 system/manager
fromuser=OMS_OWNER
touser=system
show=n
log=c:\990508.log
ignore=y
analyze=y
file=c:\990705.dmp
After execution, some tables are imported successfully, some are not. For example:
IMP-00017: following statement failed with ORACLE error 921:
"ALTER TABLE "JUDGES" MODIFY DEFAULT"
IMP-00003: ORACLE error 921 encountered
ORA-00921: unexpected end of SQL command
From the 990705.log, it says the
"Judge" table was exported successfully, but I can not import
it into my server. Why this happened?
If I choose to use data set 1, how can I mount the huge foreign data to my existing OracleServiceORCL ? Do I need to make changes to Initxxx.ora or some other files? Can somebody give me some detailed procedures?
Thanks for your help. Received on Sat Jul 10 1999 - 17:53:20 CEST