Home » RDBMS Server » Server Utilities » Export issues
Export issues [message #247959] Wed, 27 June 2007 11:33 Go to next message
whited05
Messages: 10
Registered: May 2005
Location: Lansdale, PA
Junior Member
We have a 3rd party application that contains a table that has a LONG RAW column in it. We need to do an export of this table nightly. Currently we are using the export utility with a where clause to break it up. The table contains 125,000,000 Million rows and is approxametly 50 gig. Currently it take about 4 hours to do this export. is there any way to speed this up or anoother approach that may work?

Thanks in advance.
Re: Export issues [message #247961 is a reply to message #247959] Wed, 27 June 2007 11:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Partition the table accordingly to your where clause.
Put each partition in a distinct tablespace.
Use RMAN and backup the "current" tablespace.

Regards
Michel
Re: Export issues [message #247962 is a reply to message #247961] Wed, 27 June 2007 11:38 Go to previous messageGo to next message
whited05
Messages: 10
Registered: May 2005
Location: Lansdale, PA
Junior Member
Unfortunetly I don't think you can partition a table with a long raw column.
Re: Export issues [message #247969 is a reply to message #247962] Wed, 27 June 2007 11:58 Go to previous message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Unfortunatly you're right.
Sorry.

Regards
Michel
Previous Topic: control file enhancement in sql loader.
Next Topic: why does an export of an empty table with DATAPUMP over 11 Seconds
Goto Forum:
  


Current Time: Tue Dec 06 06:32:59 CST 2016

Total time taken to generate the page: 0.27686 seconds