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" <[EMAIL PROTECTED]> 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 > > >>> [EMAIL PROTECTED] 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 <[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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Janardhana Babu Donga > 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: Ron Rogers > 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: Janardhana Babu Donga > 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: Oracle Mailing List 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).