Home » RDBMS Server » Server Utilities » exporting in Sun Solaris
exporting in Sun Solaris [message #144996] Sun, 30 October 2005 23:07 Go to next message
ozzy80
Messages: 55
Registered: June 2005
Member
Hello all,

I am not a DBA, but am asked to do export of a database on a dev server to our unix box in another server for later use. Please let me know how can I do this.

Can anyone tell me in detailed steps on what to do.

Thank you
Re: exporting in Sun Solaris [message #145009 is a reply to message #144996] Mon, 31 October 2005 03:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.orafaq.com/node/230
http://oraclesvca2.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm#1013411
Re: exporting in Sun Solaris [message #145087 is a reply to message #144996] Mon, 31 October 2005 18:51 Go to previous messageGo to next message
ozzy80
Messages: 55
Registered: June 2005
Member
Thanks Mahesh, I read thru the second link of urs' but can u tell me what am I missing by not choosing FULL=Y while exporting... looks like to do FULL=Y u have to have the DBA permissions, which I don't and I did the export something like this today...

exp scott/tiger file=<file> log=<log>

this command worked for me... can u plz let me know would I be missing something by just doing this and not giving FULL=Y option...

thanx for all ur efforts...

ozzy
Re: exporting in Sun Solaris [message #145143 is a reply to message #145087] Tue, 01 November 2005 04:42 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You will be exporting only the schema/user mentioned.
Not the whole database.
Re: exporting in Sun Solaris [message #145162 is a reply to message #145143] Tue, 01 November 2005 07:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
and always export with COMPRESS=n
Re: exporting in Sun Solaris [message #145241 is a reply to message #145162] Tue, 01 November 2005 21:55 Go to previous messageGo to next message
ozzy80
Messages: 55
Registered: June 2005
Member
what is the major advantage that we get by doing compress=N??? thanx for ur inputs...
Re: exporting in Sun Solaris [message #145313 is a reply to message #145241] Wed, 02 November 2005 07:07 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm#1005596
Previous Topic: Zipping a DMP File
Next Topic: resultset
Goto Forum:
  


Current Time: Mon Jul 01 12:21:59 CDT 2024