For a full import to a test machine, just the tablespaces. need to be the same.
>>> Connie Milliken <[EMAIL PROTECTED]> 03/08/01 11:25AM >>>
Are there any file size limitations for exp/imp on NT like there are on
UNIX? We have an 8GB db that we want to do a full exp/imp on. Are
there any issues we could run into due to the size?
To do a full, imp, do just the tablespace names have to be the same as
the db the exp was taken from or do the datafiles and their directory
structures need to be exactly the same?
We want to do a full exp from a prod system and imp into a dev database
that is an old copy of prod. Do we just need to drop all the users and
their schemas in dev (except for System) to to do the full imp?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Connie Milliken
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
--
Author: William Beilstein
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
