Re: Oracle 8 database migration ?

Hi Phillip
You shouldn't import this in the system account, you should have pre-created the OMS_OWNER. System should be untouched, or your database will be out of control.
The 921 error probably is being caused by the buffer parameter on import (the default as you didn't specify anything) is not equal to the buffer parameter on export. The default export buffer = 4096, the default import is 3072. Don't ask me why, it has been so since ages. You can't use dataset 1, as this means the datadictionary contained in sys1trn.ora needs to be merged with the dictionary of your local server. There's only one way to do this: exp/imp.

Hth,

Sybrand Bakker, Oracle DBA

Phillip Fei <xfei_at_bellsouth.net> wrote in message news: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:
>
> 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 Fri Jul 09 1999 - 12:38:42 CDT