| import problem urgent [message #74033] |
Fri, 27 August 2004 22:45  |
dilip kumar
Messages: 111
Registered: December 2003
|
Senior Member |
|
|
Hi
i am having dumpfile of 8gb which i need to import when i importing it i m getting the following error messages
'sys.dbms_logrep_imp.instantiate_schema' must be declared
'invalid option'
encounterd the error -922
pls can anyone tell how to fix it i am using Oracle 9.0 on solaris 8
|
|
|
|
| Re: import problem urgent [message #74037 is a reply to message #74033] |
Sat, 28 August 2004 23:33  |
Ramesh C
Messages: 1
Registered: August 2004
|
Junior Member |
|
|
Saw it a long time ago while importing an export set.
In this case I would have expected an out of space error.
Do you have a long raw col ? Sounds unreasonable but, is it possible to list out the datatypes in the 8gb data?
later,
RC
|
|
|
|
| Re: import problem urgent [message #74051 is a reply to message #74037] |
Tue, 31 August 2004 12:00 |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
You can import as follows:
imp file=export.dmp indexfile=create_objects.sql
so, instead of importing data, all create table/index statements will be sored into file create_objects.sql so you can use it to re-create objects prior to importing, or, you can see datatypes in that file.
Best luck.
www.consultoria-oracle.com
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
