You don't have to drop the users or their objects but you need to at
minimum truncate the tables or the imported data will be APPENDED to
the existing data.
ignore=y will ignore the create error on the object but will still load
the data.
- "Farnsworth, Dave" <DFarnsworth_at_Ashleyfurniture.com> wrote:
> Is it necessary to drop the users and/or their objects? I guess I
> was
> not planning on dropping them. The "IGNORE=Y", will this cause the
> import to skip an object if it already exists, but it will still
> import
> the data???
>
> Thanks again Rachel,
>
> Dave
>
> -----Original Message-----
> Sent: Tuesday, February 05, 2002 1:25 PM
> To: Multiple recipients of list ORACLE-L
>
>
> yes that should work because you aren't doing a full db import which
> is
> the only way you can destroy the files.
>
> I might do "ignore=y" as well
>
> are you going to drop the users first, drop just their objects or
> only
> truncate the objects?
>
> if you drop the users, you will need to recreate them or the import
> will load everything into "mylogin"
>
> for safety's sake, I'd probably run the import once for each user,
> and
> have "fromuser=" and "touser=" in the parfile
>
>
> --- "Farnsworth, Dave" <DFarnsworth_at_Ashleyfurniture.com> wrote:
> > Thanks to everyone for their help. Since these are the same schema
> I
> > see no reason why to do a full import. Anyway, I am in learning
> mode
> > and need to learn about possible parameters to use. I am going to
> do
> > an
> > owner import from my full export file since I only need a few of
> the
> > owners schema's. I'll first creat my PARFILE like
> >
> > FILE=C:\my_export_file.dmp
> > FROMUSER=(dorkboy,geekgirl,sheep_lover,monkey_spanker)
> > GRANTS=Y
> > INDEXES=Y
> >
> >
> > Then do a
> >
> > SET ORACLE_SID=my_test_db
> >
> > then
> >
> > IMP my_login/my_dirty_pwd parfile=my_parfile.dat
> >
> > My login to test is different from my live database login so I
> should
> > be
> > covered there. Does this look like it will work so that it will
> not
> > try
> > to write to the datafiles of my live database? Remember, the file
> I
> > am
> > importing into my test database is an export from my live database
> > which
> > both reside on the same server but have their data on different
> > drives.
> >
> > Thanks much everyone,
> >
> > Dave
> >
> > -----Original Message-----
> > Sent: Tuesday, February 05, 2002 10:10 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > 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
>
=== 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 - 14:37:15 CST
