Babu
I've never done this either. Maybe someone else on the list has.
1) You can edit the export file. Use the Unix strings and fold commands to
make it more manageable, then create a SQL procedure that will create the
object. Just did that this afternoon with a table definition.
2) If you import the user with IGNORE=N, it should error out on existing
objects and create objects that don't exist. Never tried that one, would
need to test first.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Tuesday, March 25, 2003 4:39 PM
To: '[EMAIL PROTECTED]'
Cc: DENNIS WILLIAMS
Dennis,
Thanks for your reply. Iam not clear about exporting/importing
packages/stored procs, specifically importing them.
If I need to export packages, I could use owner=FINANCE and rows=N. It will
export the structure of the complete schema tables also.
If I need to import one package (lost/dropped for some reason) owned by say
FINANCE schema, how can I import it?
Thanks,
-- Babu
-----Original Message-----
Sent: Tuesday, March 25, 2003 2:02 PM
To: Multiple recipients of list ORACLE-L
Babu
Another thing to consider. Have you tried to import one of these monster
tables? A recovery that takes days may not be acceptable.
[1] How can I reconstruct a database using this type of export if needed?
Consider the real purpose of a logical backup to restore selected tables
or other objects, not an entire database. If your system tablespace gets
nailed you will probably use your cold backup to recover.
[2] How can I simulate full export in this type (Table Mode) of export?
Export to /dev/null?
[3] How can I export packages/stored procs and import to new DB if
necessary?
USER export with rows=n
[4] Is there any other way to export the full database and eliminate the
static partitions in a single step?
You'll need to list tables and omit certain tables.
You could export based on a SQL statement such that you omit the data
you don't want to export.
[5] What is the best way to solve my export problem??
I think you're on the right track.
You might also want to look at TRANSPORTABLE TABLESPACES.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Tuesday, March 25, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L
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
--
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: DENNIS WILLIAMS
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: DENNIS WILLIAMS
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).
