Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help !!! What's the best way to export 43G data.
Hi,
if it is possible shutdown the database and open it in restricted access. Then export the tablespaces you need. If you need only a backup, activate the archiving and make a online backup, while the database is working.
cu,
Martin
"K.P, Ng" <kapang_at_i-cable.com> schrieb im Newsbeitrag
news: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 - 14:25:40 CDT