Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Large Export Problem ......

Re: Large Export Problem ......

From: Oracle Mailing List <orclbabu_at_hotmail.com>
Date: Wed, 26 Mar 2003 13:06:01 -0800
Message-ID: <F001.00573B00.20030326130601@fatcity.com>


you might also want to capture the database outline in OEM (in change manager)

then if you happen to lose a procedure - u can ask oem to do a diff between yr database and the stored outline and then ask it to generate a script to sync them.

babu
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, March 26, 2003 2:34 PM

> Ron,
>
> It seems to be the correct answer I believe. If the package is lost I
should
> ask the developer to get it from the version control system and I should
> compile it. This seems to be the right approach rather than importing the
> dump file and get a big list of errors.
>
> After seeing the responses from the list members, I got a clear idea how
to
> handle the
> "Large Export Problem". I will break up the export into 4 types(full
export
> with norows, static, non-static and the rest), schedule them to fit our
> schedule, and use the version control system approach for the
> packages/stored procs. Importing the dumpfile to restore the package as
last
> resort.
>
> Thanks for all those who replied.
>
> -- Janardhana
>
> -----Original Message-----
> Sent: Wednesday, March 26, 2003 10:39 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Babu,
> It may not be THE correct answer but I keep all of the packages
> created by the development community on a disk as the txt or sql
> statemants used to create them. It helps to have them handy when they
> need to be modified because of a table structure change, etc. I just
> give them back to the deveopers to fix and then I recompile on the
> production server. Also it help to keep them up to date as we are
> currently migration to a newer version of Oracle while changing the
> structure of some tables.
> With the current sql used to create the package that was distroyed you
> can recreate it easily.
> Ron
>
> >>> jbdonga_at_ucdavis.edu 03/25/03 07:33PM >>>
> Thanks for the caution. Does any one know if I export with
> owner=<schema
> Name> rows=N, then drop a package and import from the export file with
> IGNORE=N (which is default), will it restore the dropped package and
> error
> out on all other objects as they are already exist?
>
> Is this the right way of restoring the dropped package or will it have
> any
> problems? There are plenty of the tables in the database and error list
> will
> be too long in this case. Any side effects? or Is there any other way
> to
> import a dropped pakage?
>
> A little bit uncomfortable seeing big error list for restoring one
> package.
> Any ideas or will I have to live with this in case the need arises?
> Iam
> afraid of any side effects.
>
> --Babu
>
> -----Original Message-----
> Sent: Tuesday, March 25, 2003 3:54 PM
> To: Multiple recipients of list ORACLE-L
>
>
> The problem with direct=y is that imports done from these dumps
> are then very version dependent.
>
> Jared
>
>
>
>
>
>
> Govindan K <gkatteri_at_yahoo.co.uk>
> Sent by: root_at_fatcity.com
> 03/25/2003 02:49 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> 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 <jbdonga_at_ucdavis.edu> 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: gkatteri_at_yahoo.co.uk
>
> 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: ListGuru_at_fatcity.com (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: Jared.Still_at_radisys.com
>
> 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: ListGuru_at_fatcity.com (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: Janardhana Babu Donga
> INET: jbdonga_at_ucdavis.edu
>
> 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: ListGuru_at_fatcity.com (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: Ron Rogers
> INET: RROGERS_at_galottery.org
>
> 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: ListGuru_at_fatcity.com (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: Janardhana Babu Donga
> INET: jbdonga_at_ucdavis.edu
>
> 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: ListGuru_at_fatcity.com (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: Oracle Mailing List
  INET: orclbabu_at_hotmail.com

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: ListGuru_at_fatcity.com (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).
Received on Wed Mar 26 2003 - 15:06:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US