Q: Oracle 8 database migration ?

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:

1. 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.
2. 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 - 10:53:20 CDT