OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Export issues

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

Export issues [message #247959]

Wed, 27 June 2007 11:33

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.

Report message to a moderator

Re: Export issues [message #247961 is a reply to message #247959]

Wed, 27 June 2007 11:37

Michel Cadot
Messages: 68665
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

Report message to a moderator