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: Ron Thomas <rthomas_at_hypercom.com>
Date: Wed, 26 Mar 2003 12:53:52 -0800
Message-ID: <F001.00573ACA.20030326125352@fatcity.com>

FWIR, CVS doesn't handle binaries tho. We do the same thing for rdf's (report files) and fmb's (forms files) too.

Ron Thomas
Hypercom, Inc
rthomas_at_hypercom.com
Each new user of a new system uncovers a new class of bugs. -- Kernighan

                                                                                                                                                    
                      Jared.Still_at_radis                                                                                                             
                      ys.com                   To:       ORACLE-L_at_fatcity.com                                                                       
                      Sent by:                 cc:                                                                                                  
                      root_at_fatcity.com         Subject:  RE: Large Export Problem ......                                                            
                                                                                                                                                    
                                                                                                                                                    
                      03/26/2003 12:48                                                                                                              
                      PM                                                                                                                            
                      Please respond to                                                                                                             
                      ORACLE-L                                                                                                                      
                                                                                                                                                    
                                                                                                                                                    




I like RCS for this. Any version you need can be retrieved.

If a large number of packages are used for an app, you could take it a step further and use CVS. This would allow app level releases as well.

Jared

"Ron Thomas" <rthomas_at_hypercom.com>
Sent by: root_at_fatcity.com
 03/26/2003 11:09 AM
 Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc:
        Subject:        RE: Large Export Problem ......



I go even one step further here. Each object is required to have it's own creation script. A
package will have two scripts, one for the header and one for the body. Also the script name has
the package revision included in it as well. For example:

hyp_packages.115.00.sql
hyp_packageb.115.00.sql
hyp_packageb.115.01.sql

etc...

This makes reverting code and tracking changes much easier.

Ron Thomas
Hypercom, Inc
rthomas_at_hypercom.com
Each new user of a new system uncovers a new class of bugs. -- Kernighan

                      RROGERS_at_galottery
                      .org                     To: ORACLE-L_at_fatcity.com

                      Sent by:                 cc:
                      root_at_fatcity.com         Subject:  RE: Large Export
Problem ......
                      03/26/2003 11:39
                      AM
                      Please respond to
                      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


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: Ron Thomas
  INET: rthomas_at_hypercom.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:
  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: Ron Thomas
  INET: rthomas_at_hypercom.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 - 14:53:52 CST

Original text of this message

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