Re: exp/imp on NT

Go to the LazyDBA website, to scripts scripts and get the scripts on exporting and importing compressed files thru pipes written by Rachel Carmichael. These will create .dmp files of 2 gig which is the limit. You can edit these files to fit your needs.

Ruth

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, March 08, 2001 11:25 AM

> 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: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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