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

You did not say your platform. If you have a tape drive that can take 40GB (some DLT's can), then you can export the entire database to an unlabled tape (in Unix, something like file=/tape/rmt0). This technique gets around file capacities, but does limit to media capacity.

You might also check what is data and what is indexes. If you have 32G in the tablespace, it could be 16GB or less of data, the rest in indexes. Indexes are not exported (only their definitions). Import rebuilds them.

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<997124091.11261.0.nnrp-08.9e984b29_at_news.demon.co.uk>...
> 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
> >
> >
> >
Received on Mon Aug 06 2001 - 15:46:29 CDT