No, it handles binary files. It's been awhile since you used it. :)
http://ccvs.cvshome.org/fom//cache/223.html
Jared
"Ron Thomas" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/26/2003 12:53 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Large Export Problem ......
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
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
[EMAIL PROTECTED]
ys.com To: [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/26/2003 11:09 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
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
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
[EMAIL PROTECTED]
.org To: [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] 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
>>> [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: Ron Thomas
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: Ron Thomas
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).
