| full import [message #169021] |
Mon, 24 April 2006 13:37  |
hzglc
Messages: 4
Registered: April 2006
|
Junior Member |
|
|
Hi all,
I am using exp/imp to copy a small instance from unix to windows.
As instructed by the docuemnts, I did an exp dump, ftp the dump to local, created all tabelspaces with the same names, then I exe the imp full=y command. The log file says successfully without warnings. But none of the users,objects,roles are created, and all of the tables are skipped. Looks like the imp statment is just a dry run.
I am wondering: is the imp command supposed to execute all the DDLs? if so, where am i wrong?
OR how should I do this correctly?
Really confused. Thanks for any help
[Updated on: Mon, 24 April 2006 13:38] Report message to a moderator |
|
|
|
|
|
| Re: full import [message #169024 is a reply to message #169021] |
Mon, 24 April 2006 13:46  |
hzglc
Messages: 4
Registered: April 2006
|
Junior Member |
|
|
I tried
imp userid=system/**** file=fullemp20060422.dmp log=imp20060422.log full=y feedback=5000 show=y
also tried imp userid=system/**** file=fullemp20060422.dmp log=imp20060422.log full=y feedback=5000 indexes=n rows=n indexfile=test.sql show=y
seems no matter what i do, the imp command is just giving me a dry run, i.e. no objects are created.
[Updated on: Mon, 24 April 2006 13:46] Report message to a moderator |
|
|
|
| Re: full import [message #169025 is a reply to message #169021] |
Mon, 24 April 2006 13:51 |
hzglc
Messages: 4
Registered: April 2006
|
Junior Member |
|
|
|
Thanks so muc, Mahesh Rajendran! I could not believe I used the show=y there. Once I removed it, it worked. Sorry, this is the first time I am doing this. Be forgiving, please.
|
|
|
|
|
|
| Re: full import [message #169027 is a reply to message #169026] |
Mon, 24 April 2006 13:57 |
hzglc
Messages: 4
Registered: April 2006
|
Junior Member |
|
|
|
yes. I copied the command from somewhere and assumed "show" means print everything in screen. Another good lesson.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
