Home » RDBMS Server » Server Utilities » Schema export import (Oracle 11g,Unix)
Schema export import [message #517830] Thu, 28 July 2011 10:18 Go to next message
Smith14
Messages: 38
Registered: July 2011
Location: India
Member
Hi ,

I did schema export using below command.

exp jack/test12 file=schemaexp.dmp log=schemaexp.log owner='HENRY','MARK','EMANUEL','SWAN','LORDSON','JENNY','MARIE' rows=y direct=y constraints=y compress=no

The export was sucessful.

To import these schemas, create users and then import users one by one or
is there any way to import all these schemas in one shot ?


Thank you
Re: Schema export import [message #517834 is a reply to message #517830] Thu, 28 July 2011 10:30 Go to previous messageGo to next message
cookiemonster
Messages: 10590
Registered: September 2008
Location: Rainy Manchester
Senior Member
look at fromuser and touser parameters in imp documentation.
Re: Schema export import [message #517835 is a reply to message #517830] Thu, 28 July 2011 11:00 Go to previous messageGo to next message
Michel Cadot
Messages: 57642
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can also just use an import in full mode as you want ALL users.

Why do you still use the old exp/imp in 11g? (By the way, ALWAYS post your Oracle version with 4 decimals.)
You will much more and interesting features with DataPump.

Regards
Michel
Re: Schema export import [message #517836 is a reply to message #517835] Thu, 28 July 2011 11:14 Go to previous messageGo to next message
Smith14
Messages: 38
Registered: July 2011
Location: India
Member
Quote:
You can also just use an import in full mode as you want ALL users.



This will only work if i had taken the full schema export i guess.

Please clarify..
Re: Schema export import [message #517837 is a reply to message #517836] Thu, 28 July 2011 11:22 Go to previous messageGo to next message
Smith14
Messages: 38
Registered: July 2011
Location: India
Member
I gave below command to import and ended with error.

imp jack/test12 file=schemaexp.dmp log=schemaimp.log fromuser=HENRY touser=HENRY commit=y ignore=y


Import: Release 10.2.0.1.0 - Production on Thu Jul 28 21:45:59 2011

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


Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

IMP-00002: failed to open schemaexp.dmp for read
Import file: EXPDAT.DMP >


Can you tell me how to fix this error?

Thank you

Re: Schema export import [message #517838 is a reply to message #517837] Thu, 28 July 2011 11:27 Go to previous messageGo to next message
BlackSwan
Messages: 21967
Registered: January 2009
Senior Member
>Can you tell me how to fix this error?
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

00002, 00000, "failed to open %s for read"
// *Cause:  Import failed to open the export file for reading. This message is 
//          usually followed by a device message from the operating system. 
// *Action: Take appropriate action to restore the device. 


I suspect file does not exist within current directory.
You did not post sufficient details to ascertain exact cause
Re: Schema export import [message #517839 is a reply to message #517838] Thu, 28 July 2011 11:30 Go to previous messageGo to next message
Smith14
Messages: 38
Registered: July 2011
Location: India
Member

yes, you are correct black swan.I took export in unix env and running the import in windows prompt.. Sorry got confused... Smile


Re: Schema export import [message #517895 is a reply to message #517839] Fri, 29 July 2011 04:42 Go to previous messageGo to next message
Smith14
Messages: 38
Registered: July 2011
Location: India
Member
I gave the below import command in one file called imp_schema.sh and gave permission to imp_schema.sh file

chmod 777 imp_schema.sh

when i give nohup ./imp_schema.sh & to run the schema import , i get error

/imp_schema.sh: imp: Execute permission denied.


How to fix this?
Re: Schema export import [message #517897 is a reply to message #517895] Fri, 29 July 2011 04:54 Go to previous messageGo to next message
Michel Cadot
Messages: 57642
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have not the privilege to execute imp.

Regards
Michel
Re: Schema export import [message #517900 is a reply to message #517897] Fri, 29 July 2011 05:16 Go to previous messageGo to next message
Smith14
Messages: 38
Registered: July 2011
Location: India
Member
Can you tell me how to give the execute privilege to run the import ?


Thank you

[Updated on: Fri, 29 July 2011 05:22]

Report message to a moderator

Re: Schema export import [message #517902 is a reply to message #517900] Fri, 29 July 2011 06:04 Go to previous message
Michel Cadot
Messages: 57642
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe as you told us:
chmod 777 imp

Regards
Michel
Previous Topic: Want to convert exp script to expdp script
Next Topic: Export dump file
Goto Forum:
  


Current Time: Wed Apr 23 18:28:34 CDT 2014

Total time taken to generate the page: 0.11602 seconds