| Reg. Importing DMP files [message #25512] |
Tue, 29 April 2003 22:45  |
M.N.Swaminathan
Messages: 10
Registered: May 2002
|
Junior Member |
|
|
Hi guys,
i exported oracle data to dmp file...i have two users in it... say x and y ... i exported user x using exp command... but to my suprise it is exporting all the user tables... then i tried importing the same to a fresh oracle server... but it is giving fatal error on imp command...
kindly help me to get ride of that error... !!!
pri
|
|
|
|
|
|
| Re: Reg. Importing DMP files [message #25520 is a reply to message #25512] |
Wed, 30 April 2003 06:15  |
B
Messages: 327
Registered: August 1999
|
Senior Member |
|
|
When you export an user, you export the whole schema ( TABLES, INDEXES etc... )
When you import a specific user you must create it in the DB, with correct privileges before running imp.
|
|
|
|
| Re: Reg. Importing DMP files [message #25523 is a reply to message #25512] |
Wed, 30 April 2003 07:52 |
Anand
Messages: 161
Registered: August 1999
|
Senior Member |
|
|
You may have to do an 'User'-level import. Your export file contains all schemas. But, you can only import user 'X'. Just say ...
$ imp user/pwd file=xyz.dmp log=xyz.log Full=n fromuser=X touser=Y ignore=Y buffer=8192000
Remember... when you do an user-level import, u have to create the user well before the import. Oracle doesn't create the user automatically. It only creates users in case of FULL import.
hope it's clear.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
