Rachel and everyone else,
Thanks much for your help in helping me do my first import/export. It actually worked
the first time like I hoped it would. I went with the import by user schema. Got a
couple of errors at the end of my import on some Replication procedures that are
invalid but I don't use replication(yet). I will fix those errors when time permits.
Again, thanks to all.
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
> > > 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).
> --
> 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
>
=== 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).
--
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).
Received on Thu Feb 07 2002 - 12:11:45 CST
