RE: export/import on the same server

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