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. " --- אדר_יחיאל <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] > > > -----Original Message----- > > From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] > > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).