Home » RDBMS Server » Server Utilities » Need to export the schema which contains of more than 100 GB using compressed mode (Oracle 9i)
Need to export the schema which contains of more than 100 GB using compressed mode [message #465279] Tue, 13 July 2010 06:51 Go to next message
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.
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10621
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
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 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Is it possible to export based on filesize parameter in exp command.
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 Go to previous message
Michel Cadot
Messages: 58960
Registered: March 2007
Location: Nanterre, France, http://...
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
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:
  


Current Time: Wed Sep 03 03:32:18 CDT 2014

Total time taken to generate the page: 0.08476 seconds