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 [EMAIL PROTECTED] > -----Original Message----- > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] > 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. " > > > > --- ���_����� <[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). > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > 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: [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).
