OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » import a schema (Oracle 10g,Windows Xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

import a schema [message #433270]

Tue, 01 December 2009 03:02

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?

Report message to a moderator

Re: import a schema [message #433275 is a reply to message #433270]

Tue, 01 December 2009 03:20

Michel Cadot
Messages: 68643
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

Littlefoot
Messages: 21807
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.

Report message to a moderator

Re: import a schema [message #434356 is a reply to message #433275]

Tue, 08 December 2009 22:58

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.

Report message to a moderator

Re: import a schema [message #434357 is a reply to message #434356]

Tue, 08 December 2009 23:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

imp username/password file=exp_C101_SEARCHSEED_0808.dmp rows=no show=yes log=capture.log

Report message to a moderator

Re: import a schema [message #434358 is a reply to message #434357]

Tue, 08 December 2009 23:09

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

Report message to a moderator