No biggie -- I just know it because that was how we used to build our contingency database a few jobs back. :)
--- אדר_יחיאל <[EMAIL PROTECTED]> wrote: > 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 > === message truncated === __________________________________________________ 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).
