Home » RDBMS Server » Server Utilities » import a schema (Oracle 10g,Windows Xp)
import a schema [message #433270] Tue, 01 December 2009 03:02 Go to next message
prejib
Messages: 126
Registered: March 2009
Location: India
Senior Member
Hi,
I have a exported dmp file long back and I forgot the schema name used in the dmp file . While I am trying to import the data, the fromUser specified is not matching. Is any way to ignore the from user option?
Re: import a schema [message #433275 is a reply to message #433270] Tue, 01 December 2009 03:20 Go to previous messageGo to next message
Michel Cadot
Messages: 63804
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No there is no way to ignore it.
You can know the source schema reading the first few lines of your dmp file.

Regards
Michel

[Updated on: Tue, 01 December 2009 03:21]

Report message to a moderator

Re: import a schema [message #433279 is a reply to message #433270] Tue, 01 December 2009 03:28 Go to previous messageGo to next message
Littlefoot
Messages: 20825
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Do you need to know the source schema name, anyway? If it is an export file created from only one schema (i.e. not a full database export), simply import it into another schema. It will warn you that the objects were exported by SOURCE_SCHEMA_NAME, not by you (how convenient, you'll see its name!), but import should be successful.
Re: import a schema [message #434356 is a reply to message #433275] Tue, 08 December 2009 22:58 Go to previous messageGo to next message
prejib
Messages: 126
Registered: March 2009
Location: India
Senior Member
I want to import the data to a schema called search . But the fromuser name is not matching . Can you please help me to find out the fromuser ?

$imp file=exp_C101_SEARCHSEED_0808.dmp log=impdp_search_09dec.log fromuser=search touser=search ignore=y constraints=n

Import: Release 10.2.0.2.0 - Production on Wed Dec 9 10:15:01 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Username: system

Password:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path

Warning: the objects were exported by SYS, not by you

import done in US7ASCII character set and UTF8 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
export server uses AL16UTF16 NCHAR character set (possible ncharset conversion)
IMP-00034: Warning: FromUser "SEARCH" not found in export file
Import terminated successfully with warnings.
Re: import a schema [message #434357 is a reply to message #434356] Tue, 08 December 2009 23:03 Go to previous messageGo to next message
BlackSwan
Messages: 24906
Registered: January 2009
Senior Member
imp username/password file=exp_C101_SEARCHSEED_0808.dmp rows=no show=yes log=capture.log
Re: import a schema [message #434358 is a reply to message #434357] Tue, 08 December 2009 23:09 Go to previous messageGo to next message
prejib
Messages: 126
Registered: March 2009
Location: India
Senior Member
Not working

imp system/admin file=exp_C101_SEARCHSEED_0808.dmp rows=no show=yes log=capture.log

Import: Release 10.2.0.1.0 - Production on Wed Dec 9 10:33:55 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

Export file created by EXPORT:V10.02.01 via conventional path

Warning: the objects were exported by SYS, not by you

import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
export client uses US7ASCII character set (possible charset conversion)
IMP-00031: Must specify FULL=Y or provide FROMUSER/TOUSER or TABLES arguments
IMP-00000: Import terminated unsuccessfully
Re: import a schema [message #434359 is a reply to message #434358] Tue, 08 December 2009 23:16 Go to previous messageGo to next message
BlackSwan
Messages: 24906
Registered: January 2009
Senior Member
imp system/admin file=exp_C101_SEARCHSEED_0808.dmp rows=no show=yes log=capture.log full=Y
Re: import a schema [message #434360 is a reply to message #434359] Tue, 08 December 2009 23:24 Go to previous message
prejib
Messages: 126
Registered: March 2009
Location: India
Senior Member
Thanks a lot Smile
Previous Topic: sql ldr
Next Topic: Export Test database to remote windows location
Goto Forum:
  


Current Time: Mon Sep 26 23:10:58 CDT 2016

Total time taken to generate the page: 0.09913 seconds