exp/imp on NT

From: Connie Milliken <cemail_at_sprintmail.com>
Date: Thu, 08 Mar 2001 08:34:52 -0800
Message-ID: <F001.002C72A0.20010308082544@fatcity.com>

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). Received on Thu Mar 08 2001 - 10:34:52 CST