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.
This is our environment:
RS/6000 with AIX4.3
Oracle 8.1.5 (except the default tablespace create during setup the
database, there only ONE user tablespace named: PROD1.) and there totally 17
datafiles in this tablespace.
What we want to do:
1.) export the entire the database (because my boss want to keep ORIGINAL
configuration: e.g index, roles, profiles, constraints, etc.)
2.) the export command "exp" will run on a Windows NT server through SQL
Plus.
Questions:
1.) Can I export the entire database to the NT server directly without
export the file to the RS/6000 first.
2.) If I can perform above tasks. Is "exp system/password_at_production full=y
inctype=complete file=d:\data\full.dmp" ok??? or any comments.
3.) Can I import the entire database to the one that I setup in Windows NT.
I simulate this process in a Solaris x86 to Windows NT server by using ftp
to transfer the dump file to the NT server. However, I saw a lot of error
during import the database. Is it normal to import an entire database from
one database to other database.
K.P, Ng
"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 Tue Aug 07 2001 - 11:00:41 CDT