Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to use sys as sysdba to import database

592815Aug 9 2009 — edited Aug 12 2009

Hi Experts,

I get a copy of 9.0.6.0 oracle full exp of database. it exp as sysdba. ( sys, system .. with different pw).
I try to import into oracle10.2.0.4 . both database is in window 2003 32 bit system.

before delete old data, i create a new DB for imp testing
and imp as
imp \'USERID=sys/passw0rd@test AS SYSDBA\' full=Y CONSTRAINTS=Y FILE=V:\exp_test20090729.dmp IGNORE=Y COMMIT=Y LOG=V:\oraexport\logs\imptest.log

I got error as

---\BIN>imp \'USERID=sys/passw0rd@test AS SYSDBA\' full=Y CONSTRAINTS=Y FILE=V:\exp_test20090729.dmp IGNORE=Y COMMIT=Y LOG=V:\oraexport\logs\imptest.log
LRM-00101: unknown parameter name ''USERID'

IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help
IMP-00000: Import terminated unsuccessfully

---\BIN>imp \'sys/passw0rd@ltest AS SYSDBA\' full=Y CONSTRAINTS=Y FILE=V:\exp_test20090729.dmp IGNORE=Y COMMIT=Y LOG=V:\oraexport\logs\imptest.log
LRM-00108: invalid positional parameter value 'AS'

IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help
IMP-00000: Import terminated unsuccessfully

ORACLE document example as imp \'username/password@instance AS SYSDBA\'

I am looking for your help.

JIm