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).
Received on Tue Feb 05 2002 - 11:11:52 CST
