Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Apr 04, 2012 05:06 AM by saffy
Member
304 Points
365 Posts
Feb 27, 2012 08:55 AM|LINK
HI,
We have a Oracle Database dump to import.
we imported using "impdp" to our server.
Can we import same database to same server to different username?
538 Points
136 Posts
Feb 27, 2012 09:11 AM|LINK
saffy,
Yes you can, the data is differentiate by the user name. As username is different in your case there is no problem.
Regards,
Feb 27, 2012 10:51 AM|LINK
I have created on new user and imported the dump to database.
But by default it has overridden existing, but not in newly created user.
Suggest.
59 Points
58 Posts
Mar 07, 2012 05:51 AM|LINK
try this
imp username/password@dbname FROMUSER=userofdump TOUSER=newuser file=D:\123.dmp log=D:\123.log
Happy Codding.
Mar 08, 2012 11:49 AM|LINK
Thank u, will try and get back.
Mar 22, 2012 11:00 AM|LINK
Thanks for suggestion but, we are getting some issue with user name.
we are using below command to import the database, its importing sucessfully be in to username 'USERB' its creating with one space at end 'USERB '
By this we are unable to connect to database.
Please suggest.
sql:
impdp user/pass FROMUSER=USERA TOUSER=USERB directory=database_imp dumpfile=DUMPFILE.dmp
\
Dipen_Chovatiya try this imp username/password@dbname FROMUSER=userofdump TOUSER=newuser file=D:\123.dmp log=D:\123.log Happy Codding.
Apr 04, 2012 05:06 AM|LINK
Final query.
IMPDP sys/system DIRECTORY=directory DUMPFILE=dumpfile.dmp REMAP_SCHEMA=EXISTINGSCHEMA:NEWSCHEMA REMAP_TABLESPACE=EXISTINGTABLESPACE:NEWTABLESPACE
saffy
Member
304 Points
365 Posts
Oracle Database dump to import
Feb 27, 2012 08:55 AM|LINK
HI,
We have a Oracle Database dump to import.
we imported using "impdp" to our server.
Can we import same database to same server to different username?
mamun22s
Member
538 Points
136 Posts
Re: Oracle Database dump to import
Feb 27, 2012 09:11 AM|LINK
saffy,
Yes you can, the data is differentiate by the user name. As username is different in your case there is no problem.
Regards,
Senior Software Engineer
Ennovia Technologies Limited
(Mark it as answer if it does help you!)
saffy
Member
304 Points
365 Posts
Re: Oracle Database dump to import
Feb 27, 2012 10:51 AM|LINK
HI,
I have created on new user and imported the dump to database.
But by default it has overridden existing, but not in newly created user.
Suggest.
Dipen_Chovat...
Member
59 Points
58 Posts
Re: Oracle Database dump to import
Mar 07, 2012 05:51 AM|LINK
try this
imp username/password@dbname FROMUSER=userofdump TOUSER=newuser file=D:\123.dmp log=D:\123.log
Happy Codding.
saffy
Member
304 Points
365 Posts
Re: Oracle Database dump to import
Mar 08, 2012 11:49 AM|LINK
Thank u, will try and get back.
saffy
Member
304 Points
365 Posts
Re: Oracle Database dump to import
Mar 22, 2012 11:00 AM|LINK
Thanks for suggestion but, we are getting some issue with user name.
we are using below command to import the database, its importing sucessfully be in to username 'USERB' its creating with one space at end 'USERB '
By this we are unable to connect to database.
Please suggest.
sql:
impdp user/pass FROMUSER=USERA TOUSER=USERB directory=database_imp dumpfile=DUMPFILE.dmp
\
saffy
Member
304 Points
365 Posts
Re: Oracle Database dump to import
Apr 04, 2012 05:06 AM|LINK
Final query.
IMPDP sys/system DIRECTORY=directory DUMPFILE=dumpfile.dmp REMAP_SCHEMA=EXISTINGSCHEMA:NEWSCHEMA REMAP_TABLESPACE=EXISTINGTABLESPACE:NEWTABLESPACE