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
Hi
All can be fine since you have to log on to the database.
However if tablespaces do not exist already before import they will be
created in the PROD directory!!
So pre-create the tablespaces log on to the test database with the import
utility and do a full import
(ignore = y)
Dave,
are you planning on completely dropping the TEST database and
recreating it from the PROD export? If so, you are right to be
cautious.
If you want to refresh the data and the number of schema owners is
small, you might consider just dropping the users and their objects
then recreating the
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]
wisernet100@cc:
yahoo.com Subject: Re: export/import on the same
server
Sent
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
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
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
-
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
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,
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 [EMAIL PROTECTED] wrote:
Is it
11 matches
Mail list logo