Re: Help !!! What's the best way to export 43G data.

Can you explain why you need to export
the whole database in one shot ?

It would also be helpful to tell us the
Oracle version number, and how much
time you have to do the job.

Possible solution:
Kick all users off
Restrict login to DBAs
Export the database structure.
Export the tables in batches to multiple export files.

--
Jonathan Lewis

Seminars on getting the best out of Oracle
Last few places available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html




K.P, Ng wrote in message <9kmgj8$61s3_at_rain.i-cable.com>...


>Dear All,

>

>We've a database with total 34GB data, where 32GB come from one tablespace

>named: PROD1. We need to export all the data from this tablespace PROD1. At

>the same time we need to maintain the data integrity, e.g roles,

 constraints


>or user privileges.

>

>Which way will be best way:

>   1. export tablespace PROD1, or

>  2. export the whole database, or

>any suggestions.

>

>B.Rgds

>

>K.P, Ng

>email: kapang_at_i-cable.com

>

>

>