OraFAQ Forum: Server Utilities » Need to export the schema which contains of more than 100 GB using compressed mode

Home » RDBMS Server » Server Utilities » Need to export the schema which contains of more than 100 GB using compressed mode (Oracle 9i)

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

Need to export the schema which contains of more than 100 GB using compressed mode [message #465279]

Tue, 13 July 2010 06:51

ram anand
Messages: 244
Registered: February 2008
Location: india

Senior Member

Hi,

I need to export one schema which contains of huge space of 100GB in oracle 9i ,can u pls provide the command to export in the compress mode.

Report message to a moderator

Re: Need to export the schema which contains of more than 100 GB using compressed mode [message #465282 is a reply to message #465279]

Tue, 13 July 2010 07:03

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I suppose you mean compressing the file for space and not looking to consolidate into one initial extent.
Depends on your OS.
In Unix, you can use pipes.
Here is an example
http://www.neooug.org/oracletab/knowledge/c_impexp.txt

Report message to a moderator

Re: Need to export the schema which contains of more than 100 GB using compressed mode [message #465288 is a reply to message #465282]

Tue, 13 July 2010 07:17

ram anand
Messages: 244
Registered: February 2008
Location: india

Senior Member

Is it possible to export based on filesize parameter in exp command.

Report message to a moderator

Re: Need to export the schema which contains of more than 100 GB using compressed mode [message #465294 is a reply to message #465288]

Tue, 13 July 2010 07:48

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes otherwise this parameter did not exist.

But if you ask if you can use this parameter and the method Mahesh Rajendran pointed you, the answer is no.

Regards
Michel

Report message to a moderator

Previous Topic:	IMPORT ERROR
Next Topic:	Re: Create a External Table in Oracle 10g:==> ERROR: KUP-01005 (split from hijacked thread by bb

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 06:19:22 CST 2025