For this kind of situation I do normally like this
Store all table names in single file.
Exp constraints=n triggers=n indexes=n tables=`cat tables.lst`
file=table_data.dmp grants=n
Import the full file or by fromuser, touser option.
-Original Message-
Sent: Tuesday, December 16, 2003 9:55 AM
To: Multiple recipients of list ORACLE-L
I need to do a refresh of a test database using production data. We use
import for this. In the past we have always dropped the schemas (4 or
5), recreated the schemas, and then did a full import with ignore=n.
This time the user does not want to lose any of the new functions and
procedures that are in test, but not in prod. Instead, they would like
to just refresh the table data. Last time we tried this we had all
kinds of trouble with functions, triggers, constraints, etc... and ended
up doing a full import.
Is there a tried and true way to just refresh the table data without
losing anything else and without having all the problems with triggers
and constraints?
Thanks!
Ron
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Smith, Ron L.
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: Pandian, Thiru
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).
