RE: export/import on the same server

Hello Rachel

It seems that I misunderstood the docs.
Just to make sure, I did a full database export and checked the output. Yip - the create tablespace statements are there. Since I have done my share of full database imports and have never seen tablespace created, I never thought that you can create tablespace during import.

Mea Culpa

Yechiel Adar, Mehish Computer Services
adary_at_mehish.co.il

> -----Original Message-----
> From: Rachel Carmichael [SMTP:wisernet100_at_yahoo.com]
> Sent: Tue, February 05, 2002 6:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: export/import on the same server
>
> unless I am misreading the 9i docs (see below) this has nothing to do
> with transportable tablespaces
>
> If you use DESTROY=Y and a full database import, Oracle will overwrite
> the datafiles as defined in the create tablespace statement that is in
> the dump file. It's the equivalent of issuing:
>
> create tablespace <tbsname> datafile '<prod file name>' reuse;
>
> >From the 9i Utilities manual:
>
> "Specifies whether or not the existing datafiles making up the database
> should be reused. That is, specifying DESTROY=y causes Import to
> include the REUSE option in the datafile clause of the CREATE
> TABLESPACE statement, which causes Import to reuse the original
> database's datafiles after deleting their contents.
>
> Note that the export file contains the datafile names used in each
> tablespace. If you specify DESTROY=y and attempt to create a second
> database on the same system (for testing or other purposes), the Import
> utility will overwrite the first database's datafiles when it creates
> the tablespace. In this situation you should use the default,
> DESTROY=n, so that an error occurs if the datafiles already exist when
> the tablespace is created. Also, when you need to import into the
> original database, you will need to specify IGNORE=y to add to the
> existing datafiles without replacing them. "
>
>
>
> --- אדר_יחיאל <adary_at_mehish.co.il> wrote:
> > Hello Dave
> >
> > I checked the docs.
> > It seems to me that destroy is associated with transport_tablespaces.
> > If you transport tablespaces destroy=y means overwrite old data files
> > with the same name.
> >
> > In regular import the @database set the target database.
> >
> > Yechiel Adar, Mehish Computer Services
> > adary_at_mehish.co.il
> >
> > > -----Original Message-----
> > > From: Farnsworth, Dave [SMTP:DFarnsworth_at_Ashleyfurniture.com]
> > > Sent: Tue, February 05, 2002 4:21 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: export/import on the same server
> > >
> > > I have a question on the export/import utility. I have my
> > live(PROD)
> > > and test(TEST) databases are on the same server. These are
> > basically
> > > the same schemas except that the data in TEST is old and that the
> > > datafiles for PROD are on I: drive and the datafiles for TEST are
> > on E:
> > > drive.
> > > My question is, since these are on the same server do I have to
> > worry
> > > about which data files will be written to during the import. For
> > > example;
> > > I do a full export of my PROD database. When I do my import into
> > my
> > > TEST database will the data automatically go to E: drive or will it
> > > still be pointing to I: drive? I am reading the Import section of
> > the
> > > fine manual but am a bit confused on the datafiles part of it when
> > doing
> > > a full export/import. Do I need to use the DESTROY=N parameter?
> > > I am new to this utility but want to learn it. I am reading the
> > manuals
> > > and some other reading material but still am not clear on this. I
> > do
> > > not want it to start overwriting my live data. That is not good
> > for job
> > > security.
> > >
> > > Thanks,
> > >
> > > Dave
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Farnsworth, Dave
> > > INET: DFarnsworth_at_Ashleyfurniture.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).
> > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > > This e-mail was scanned by the eSafe Mail Gateway
> > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
> > INET: adary_at_mehish.co.il
> >
> > 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).
>
>
> __________________________________________________
> Do You Yahoo!?
> Send FREE Valentine eCards with Yahoo! Greetings!
> http://greetings.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.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).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> This e-mail was scanned by the eSafe Mail Gateway
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-8?Q?אדר_יחיאל?  INET: adary_at_mehish.co.il

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