The problem with direct=y is that imports done from these dumps
are then very version dependent.
Jared
Govindan K <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/25/2003 02:49 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: Large Export Problem ......
Babu
Why not try 'direct=y' option. This has limitations
regarding the platform. Not 100% sure of it.
Check with Documentation. It does export very fast.
HTH
GovindanK
--- Janardhana Babu Donga <[EMAIL PROTECTED]> wrote: >
Dear List,
>
> I have a large unarchived decission support database of
> size 270gig. We do
> take coldbackup of database files every sunday. We also
> take export backup
> to suplement the coldbackup. Export is taking too much
> time which we can't
> afford now. I need to reduce the export time to fit the
> weekend schedule. In
> the last few weeks it is failing as the database is down
> for coldbackups
> while the export is running.
>
> The database structure is as follows:
>
> Partitioned tables size: 200gig
> [static partitions(prior years) size 150 gig, and
> non-static
> partitions(current yr) size 50gig]
> non-partitioned tables: 70gig
>
> I don't need to export static partitions every week. Once
> in 3/6months is
> OK. I don't think I can eliminate static partitions in
> one full export
> script/parameter file. Iam thinking of eliminating the
> static partitions by
> taking export in TABLE mode, which includes only
> NON-STATIC partitions and
> the remaining NON-PARTITION tables. I may have to
> hardcode the table names.
>
> The database has lots of packages/stored procs which will
> be stored in the
> dictionary I believe.
>
> My questions are:
> [1] How can I reconstruct a database using this type of
> export if needed?
> [2] How can I simulate full export in this type (Table
> Mode) of export?
> [3] How can I export packages/stored procs and import to
> new DB if
> necessary?
> [4] Is there any other way to export the full database
> and eliminate the
> static partitions in a single step?
> [5] What is the best way to solve my export problem??
>
> Any ideas are appreciated.
>
> Thanks,
> -- Babu
>
__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?iso-8859-1?q?Govindan=20K?=
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
