| Import [message #73563] |
Mon, 24 May 2004 03:36  |
Milind Deshpande
Messages: 93
Registered: May 2004
|
Member |
|
|
Dear Members,
I am facing a problem during Import.The problem is like this :-
i have an Full DB Export dump file about which i dont have any information like at which level the export was taken etc.
i want to Import this .dmp file in a particular user created by me. at the time of importing it first imports sys and system schemas and fires an error.
i want to import only the users skipping the sys and system users.Is there any way that we can skip the sys and system users and import only the other users exisiting in the .dmp file or there is any other way of identifying the users included in the .dmp file.
Kindly help on this.
|
|
|
|
| Re: Import [message #73565 is a reply to message #73563] |
Mon, 24 May 2004 04:24  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
-- to import to only a specific user.
-- use DBAdministrative account
--
imp dba/password fromuser=sourceuser touser=targetuser file=thedumpfile.dmp
[i]there is any other way of identifying the users included in the .dmp file.[/i]
-- Sure!~
-- use show=y and log the output to a logfile.
-- you can seee alll the details in the dumpfile
-- the username,allocated privs,tables,tablespaces etc...
imp dba/password full=y file=thedumpfile.dmp show=y log=informationindumpfile.log
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
