]
Sent by: cc:
[EMAIL PROTECTED]Subject: RE: Export / Import Question
.com
]Subject: RE: Export / Import
Question
.com
]
om cc:
Sent by: Subject: RE: Export / Import Question
I have a user who want to refresh only the DATA in a test database with
DATA from the production database. He does not want to replace any
procedures, functions, triggers, etc...
My question is, if I do a full or user level export, then turn around
and do a full or user level import with
TRIGGERS=N
On 01/09/2004 09:09:26 AM, Smith, Ron L. wrote:
I have a user who want to refresh only the DATA in a test database with
DATA from the production database. He does not want to replace any
procedures, functions, triggers, etc...
My question is, if I do a full or user level export,
Ron,
I share your feeling. All stored objects are recreated with CREATE OR REPLACE -
IGNORE=Y is inoperant for them.
IMHO the best you can do is generate as many table-level exports as you have tables,
with TRIGGERS=N. Of course, usual fun with constraints. On the bright side, you will
be
Ron - You may want to ask yourself what you're getting into. My preference
is that the developers be creating scripts to make their procedure,
function, trigger changes, along with detailed instructions for installing
them. I make my counteroffer that I will recover a copy of the production
That would require effort and planning on their part.
Ron
-Original Message-
Sent: Friday, January 09, 2004 11:05 AM
To: Multiple recipients of list ORACLE-L
Ron - You may want to ask yourself what you're getting into. My
preference is that the developers be creating scripts to make
On 01/09/2004 12:29:35 PM, Smith, Ron L. wrote:
That would require effort and planning on their part.
Ron
Ron, are your developers little, bearded men that live in the
swamps of Elbonia? Planning and effort are contrary to the
elbonian customs, but Elbonians are cheap labor.
--
Mladen
Ron - You have my sympathy.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, January 09, 2004 11:30 AM
To: Multiple recipients of list ORACLE-L
That would require effort and planning on their part.
Ron
-Original Message-
Sent: Friday,
Thanks Tom and others that replied,
That was the explanation that I needed. I also was informed that exporting
with COMPRESS=Y is a mistake due to sizing issues so I will do another
export with COMPRESS=N.
Dave
-Original Message-
Sent: Tuesday, September 04, 2001 3:48 PM
To: Multiple
.
From: Farnsworth, Dave [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Export/Import question
Date: Wed, 05 Sep 2001 03:20:56 -0800
Thanks Tom and others that replied,
That was the explanation that I needed. I also
[EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Export/Import question
Date: Wed, 05 Sep 2001 03:20:56 -0800
Thanks Tom and others that replied,
That was the explanation that I needed. I also was informed that exporting
Farnsworth, Dave wrote:
Arun,
Thanks for the suggestion. I am doing export/import because I do not know
how to ship a database to another server. For that matter, I am doing
export/import for the first time. I figured that since our DB is not a 24X7
that I could get a clean export. I
Hi,
I sort of agree with this, but had a little bit of a different idea. I
guess depending on the size of the user and how many other users it may
dependant on, why don't you just export the user? If you are exporting the
db, that means you already have Oracle installed on the other
: Export/Import question
Date: Wed, 05 Sep 2001 05:26:35 -0800
Farnsworth, Dave wrote:
Arun,
Thanks for the suggestion. I am doing export/import because I do not
know
how to ship a database to another server. For that matter, I am doing
export/import for the first time. I figured
across operating systems then shipping files would have made my life more
easier.
Well all the best
From: Stephane Faroult [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Export/Import question
Date: Wed, 05 Sep 2001 05:26
network config, pre-build tables and
stuff, etc.
regards,
ep
--
From: Farnsworth, Dave [EMAIL PROTECTED]
Date: Tue, 4 Sep 2001 13:55:48 -0500
Subject: Export/Import question
[via ORACLE-L Digest -- Volume 2001, Number 248]
...
EXP MY_NAME/MY_PASSWORD FILE=C
of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Export/Import question
Date: Wed, 05 Sep 2001 13:35:51 -0800
Wow! Please elaborate!
--
From: Jonathan Lewis [EMAIL PROTECTED]
Date: Tue, 4 Sep 2001 20:47:08 +0100
Subject: Re: Export/Import question
[via ORACLE
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arich Henneman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arich Henneman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arich Henneman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
How come I am getting only blank mails?? ... see below
-Original Message-
Sent: Thursday, 6 September 2001 11:35 AM
To: Multiple recipients of list ORACLE-L
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arich Henneman
INET: [EMAIL PROTECTED]
Fat City
Sujatha Madan wrote:
How come I am getting only blank mails?? ... see below
-Original Message-
Sent: Thursday, 6 September 2001 11:35 AM
To: Multiple recipients of list ORACLE-L
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arich Henneman
INET:
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arich Henneman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arich Henneman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Jared or Bruce:
For everyone's sanity, please unsubscribe [EMAIL PROTECTED]
who seems to have a major problem and is just an annoyance to
other list members.
Arich Henneman wrote:
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arich Henneman
INET: [EMAIL
I have a question about how the export/import utility works. My situation
is that damagement had me put my live and test environments on the same
server. Now they realize that this is not a good situation(test has crashed
the server a few times and required a re-boot, imagine that). I have
The data is stored based on tablespaces and not physical mount points.
You doing file=x tells it where to store the single export file, but the
data is stored internally to tablespaces and such.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them,
Create all tablespaces(same name as in the source database) before you
import.
-Original Message-
Dave
Sent: Tuesday, September 04, 2001 4:02 PM
To: Multiple recipients of list ORACLE-L
I have a question about how the export/import utility works. My situation
is that damagement had
Dave,
You will need to create the tablespaces before you do the import. When you
create the tablespaces, you will be creating the physical files to support
those tablespaces.
Import simply imports data to tablespaces (or, optionally, other
tablespaces).
Sooo, when you re-create your new
As ever, the answer is dependent on the current
state of play.
If the tablespaces for the data do not currently
exist, then Oracle will try to create them on
the wrong drive.
If the tablespaces do exist, it doesn't matter
where they exist - so long as they are large
enough.
Exporting with
Dave,
Import does the things in a LOGICAL way, I mean to say,
what actually import does is, it connects to already existing database as
one of
the database users and does all necessary DDLs and DMLs (and whatever)to
have the data ready
for you, as per the contents of dmp file and your import
33 matches
Mail list logo
