Re: exp/imp on NT

For a full import to a test machine, just the tablespaces. need to be the same.

>>> Connie Milliken <cemail_at_sprintmail.com> 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: cemail_at_sprintmail.com 

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: 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.com
--
Author: William Beilstein
  INET: BeilstWH_at_obg.com

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: 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).