No biggie -- I just know it because that was how we used to build our
contingency database a few jobs back. :)
- אדר_יחיאל <adary_at_mehish.co.il> 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
> adary_at_mehish.co.il
>
> > -----Original Message-----
> > From: Rachel Carmichael [SMTP:wisernet100_at_yahoo.com]
> > 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. "
> >
> >
> >
> > --- אדר_יחיאל <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).
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > 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: adary_at_mehish.co.il
>
> 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: 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 - 13:29:03 CST
