]
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,
I am trying to export a table from one database to another. Table in target database
is dropped before importing and is being created as part of import process. During
import process data Oracle is complaining Unique constraint violated and throwing out
following messages. Its complaining on
Avnish,
Are you absolutely sure that the target table is either gone before the
import, or empty? You should not be getting a unique constraint violation
if the table does not exists before import.
The step that Oracle import follows for importing is:
Create the table
import the data
create
I am 100% positive . I tried this process 2-3 times using different approach but same
output. I tried to create objects first using no data. I also tried to create objects
as part of loading data but no difference. I enabled 10046 trace for the import
process but that also didnt help, it
I think data will never change like that. Are the owners the same. Or are you doing fromuser touser.
You can use the show option to see the contents of the export dumpfile. Then make sure all objects are dropped. [EMAIL PROTECTED] wrote:
I am 100% positive . I tried this process 2-3 times using
Owners
are different. I am using fromuser touser.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of anuSent:
Wednesday, December 24, 2003 12:04 PMTo: Multiple recipients of
list ORACLE-LSubject: RE: Export/Import issue.
I think data
On ORACLE 8i, The user need import/export his schema.
I grant EXP_FULL_database and IMP_FULL_database to
this user. The user complaint he still need Local
admin right to do it under NT and Win 2000. Is it
true?
Thanks you for help.
__
Do you Yahoo!?
Yahoo!
]
Sent by: cc:
[EMAIL PROTECTED] Subject: [Q] export/import privileve
on Win NT?
ity.com
Good afternoon everyone,
I'd like to know if anyone out there is using the export/import method to copy data
from a LONG column to a CLOB column. I've been doing this for a number of months now,
but one the DBAs I spoke to thinks that this method is not supported and there may be
issues around
exp help=yes
Johnson; Michael [EMAIL PROTECTED] wrote on 1/31/03 3:34 pm:
From the O/S prompt
$EXP HELP=Y or
$IMP HELP=Y
or see the Utilities manual, I believe chapters 2 and 3.
Also, Kirti wrote up some good principles when using export and import that I
keep on file.
Im sure he could
Hello,
OS Version: HP-UX 11i
DB Version: Oracle 8.1.7.4 and 9.2.0.1
I've been looking around and I cannot seem to find a difinitive guide
online about Oracle's Export and Import. I'm looking for all of the
parameters and what they do. Could anyone point me in the right direction.
Thanks,
Never mind. After I posted, I found a good website that included all of
what I was looking for.
Just incase anyone else wants that kind of info, here is the link:
http://www.csis.gvsu.edu/GeneralInfo/Oracle/server.920/a96652/part1.htm
Thanks,
-Scott
**
From the O/S prompt
$EXP HELP=Y or
$IMP HELP=Y
or see the Utilities manual, I believe chapters 2 and 3.
Also, Kirti wrote up some good principles when
using export and import that I keep on file.
Im sure he could help you if you request it.
HTH, Mike
-Original Message-
Sent:
Title: RE: Export / Import
exp -help
-Original Message-
From: Scott Stefick [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 31, 2003 3:10 PM
To: Multiple recipients of list ORACLE-L
Subject: Export / Import
Hello,
OS Version: HP-UX 11i
DB Version: Oracle 8.1.7.4
Tracy,
I hit the same bug when doing reorg using export/import (Solaris 2.6, Oracle 8.1.7.4)
for some tables in our baan erp database. The tables had unique constraints that were
failing after the import. Found out that import has changed the values in some unique
index columns. The export
check
out note 199416.1 - talks about export corruption on certain
releases. [EMAIL PROTECTED] 1/8/03 2:44:15 PM
Tracy Rahmlow wrote: We attempted to reorg a
table and data corruption resulted. We have isolated the issue and
currently have a tar open with Oracle. But basically, when we
Tracy Rahmlow wrote:
We attempted to reorg a table and data corruption resulted. We have isolated
the issue and currently have a tar open with Oracle. But basically, when we
export the table with a buffer=10485760 the import process corrupts the data.
The row count matches, however some
We attempted to reorg a table and data corruption resulted. We have isolated
the issue and currently have a tar open with Oracle. But basically, when we
export the table with a buffer=10485760 the import process corrupts the data.
The row count matches, however some fields that initially were
Tracy,
Have a look at bug 2475331 / 2410612 RDBMS CONVENTIONAL EXPORT HAS WRONG DATA
ON IMPORT
This is listed as having happened in 8173. Bug has no details of why or who it might
affect.
1. Use direct=true and the problem would not reproduce
2. Set the buffer size 100 and the
Could you be hitting bug 2410612 : CONVENTIONAL EXPORT HAS WRONG DATA ON
IMPORT?
From: Tracy Rahmlow [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Export/Import Error and Validation !!!
Date: Tue, 07 Jan 2003 15:11:16 -0800
Good day, all:
I'm looking for real-life best-case scenarios for running import/export . .
. I've been playing with this for quite some time and would like to know how
fast I can really expect this to go, particularly for the import.
I'd be interested to hear others' experiences - how fast have
Title: RE: best case scenarios for export/import
2 x (IBM p690, 16CPU, 16GB Ram, Oracle 9201), Export file from 8161 34GB. Import is 12 parallel streams (6 on each machines) with no constraints, custom parfiles (to import certain schema per stream only), buffer (either 8M and 16M), 12GB Undo
by: Subject: best case scenarios for
export/import
[EMAIL PROTECTED
Bill - For other import tuning ideas, see
http://www.orafaq.com/faqiexp.htm
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, December 20, 2002 8:04 AM
To: Multiple recipients of list ORACLE-L
Good day, all:
I'm looking for real-life
Hi,
That doesn't sound particularly healthy to me. Depends what you're running
on I guess. We have a nightly batch job which does an import on 8.1.7,
rather weedy 933MHz Intel, 50Mb SGA, 4 x SCSI disk Linux box. The dump
file is 4.0Gb which turns out to be about 6Gb data, 1Gb indexes. It
a month ago on MS NT 4.0, I imported a 70 gig dump file in 9.5 hours. That
time includes creating the indexes.
I can't remember what the totall size used in the database...
config:
8.1.7.2.3
Win NT 4.0 Svc. Pack 6a
There's also a brand new EMC Symmetrix on the backend
- Original Message
Come on folks...Help me, I am stuck...
I run Oracle 8.1.6 on Win 2k (Both standard ed.). I am trying to run the
export wizard through the Enterprise Manager Console by doing the following:
Under Database folder, I right click the Global Name (say ORCL) - Data
Management - Export ...
and it comes
recipients of list ORACLE-L
Export/Import/Backup
Come on folks...Help me, I am stuck...
I run Oracle 8.1.6 on Win 2k (Both standard ed.). I am trying to run the
export wizard through the Enterprise Manager Console by doing the following:
Under Database folder, I right click the Global Name (say ORCL
A couple of things come to mind...
1. Set credentials for the node ORATEST, usually the user you installed
oracle with on the node.
2. Set credentials for the database to be a user with DBA privileges,
possibly even create a specific user to act as the primary user that you
will do this and other
, November 06, 2002 10:04
AM
Subject: Help required: Enterprise
Manager Console - Export/Import/Backup
Come on folks...Help me, I am stuck...I run Oracle
8.1.6 on Win 2k (Both standard ed.). I am trying to run theexport wizard
through the Enterprise Manager Console by doing
If I remember correctly ( a big if) there is an option in the OEM menus to
set the preferred credentials.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 5:04 PM
Come on folks...Help me, I am
You need to set the credentials for the node. If you are doing an export
on the node, OEM must be able to log into the node. As good practice, you
should create a valid userid and password for each node listed by OEM. OEM
cannot run a job on a node without having a userid to log onto the node
Oracle Database is Portable means that it can be ported to any OS
platform. Take a full Export of the database and then use the imp utility of
Oracle to build the exact database what was there on the previous one.
If you want to import certain objects then you need to create the tablespace
Hi -
I believe I can do this, but I would like some confirmation and or warnings,
etc. We are migrating an application from 8.0.5 on NT to 8.1.7 on Unix
(Solaris 2.6). I would like to do this by creating the 8.1.7 instance and
then importing the data. Is it possible to export from the NT
Hi
It is Possible to import from NT to Solaris. The table space name should be
the same otherwise build the table and then import by ignoring the errors.
Ayyappan.S
This communication contains information, which is
We are testing Fine-Grained Access Control to export the complete schema
excluding some tables.
This works well for export but during import it try to import all tables.
Is there any way we can restrict import of some tables using Fine-Grained
Access Control
.We are using function as specified
Harvinder,
IMHO, you are using the wrong approach. FGAC is meant for row-level
security. In fact, DBMS_RLS (RLS = Row-Level Security) is the package that
supports FGAC.
It's a lot easier to use the TABLES parameter in your export and import
parameter files to control which tables are
Hi
I have done export and import of one schema.After import the database size
has increased and I checked the tablespace which are having LOB objects grow
just twice approximately.What could be reason?
Thx
Seema
_
Send and
I just did my first export/import and of course I got some errors at the very end of
my import log file. My problem is I don't have a clue as to what they are. Below is
the last few lines of the import log file
About to enable constraints...
. importing DIS's objects into DIS
. importing
Quick look in Metalink would suggest that this is a bug, I would report this
to Oracle. I think there is a fix to it.
Lee
-Original Message-
Sent: 07 February 2002 15:29
To: Multiple recipients of list ORACLE-L
I just did my first export/import and of course I got some errors
of list ORACLE-L
Subject: export/import errors
I just did my first export/import and of course I got some errors at the
very end of my import log file. My problem is I don't have a clue as to
what they are. Below is the last few lines of the import log file
About to enable constraints
cc:
Sent by: Subject: export/import errors
[EMAIL PROTECTED
think there is a fix to it.
Lee
-Original Message-
Sent: 07 February 2002 15:29
To: Multiple recipients of list ORACLE-L
I just did my first export/import and of course I got some errors at the
very end of my import log file. My problem is I don't have a clue as to
what
, 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
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
)
Jack
Farnsworth, Dave [EMAIL PROTECTED]@fatcity.com on
05-02-2002 15:20:34
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
I have a question on the export/import
thing to do would be to drop and
recreate the TEST database, tablespaces/datafiles and all. Then use
IGNORE=Y and DESTROY=N and again MAKE SURE YOU ARE POINTING TO TEST
when you do the import.
--- Farnsworth, Dave [EMAIL PROTECTED] wrote:
I have a question on the export/import utility. I have my
PROTECTED]
-Original Message-
From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
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
PROTECTED]
wisernet100@cc:
yahoo.com Subject: Re: export/import on the same
server
Sent
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
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
]
-Original Message-
From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
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
-
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
Computer Services
[EMAIL PROTECTED]
-Original Message-
From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
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
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
Exporting an individual schema within APPS (GL /PA etc)
is not recommended due to the number of constraints that cross schemas (to fnd
tables for instance).
So
changing the block size is essentially non Apps specific and is just a straight
export /import.
Depending on your hardware and plan
Nick,
Export/Import on an Oracle Apps database is not very well supported. It is
my understanding (from another list) that a bug (or is that a feature :)
currently exists. This may not be applicable in your situation. A loss of
Java objects has been reported. Keeping in mind that Quest may need
Hi
If one of the tablespace in database is TRANSPORT TABLESPACE.I have full
export with consistent=y and full=y.
Can I full import the database?
If yes then what will happened with transport tablespace?
In case of crash can I restore full database with full export?
The assumption is we don't
I am doing a cost justification for upgrading a data warehouse from 8.0.4
to 8.1.7.
I need to submit it today and don't have time to do a test on a very large
table.
Does anyone have anecdotal evidence or experience in the time difference
required to reorg a tablespace using the export/import
and don't have time to do a test on a very large
table.
Does anyone have anecdotal evidence or experience in the time difference
required to reorg a tablespace using the export/import table method versus
alter table move to a new tablespace method?
Thanks for any time quotes you can provide. I'm
you can tweak export import better i feel as move
does not give you too many options.
we recently did a export of ~60Gb that took us about
45 minutes to complete. This speed was mainly due to
hacking of parameters like buffer etc. however this
was on a high end sun box(not 10K) .. ymmv
Deepak
]
TOUCH.COMcc:
Sent by: Subject: RE: Execution time for
export/import vs. alter table move
[EMAIL PROTECTED]tablesp
Title: full db export/import
hi list,
i wonder wat actually full db export has benefits over user level export,
cuz full db export also makes the objects of user sys and system as part of the dump file
(if i am right) , but the target database in which we are gonna import that dump file
have objects of system and sys already created then wats the
point in exporting their objects too.
for example we have two databases, 1 production and other dev,
we have almost 10 user schemas which we replicate from production db to
development db using export/import. We use to drop all the existing
Title: RE: Export - Import from Oracle v8 to v731
There is a compatible parameter for the
initsid.ora file.
The parameter is probably already there,
just set for your current version as it is generally included by default.
Do not criticize someone until you walked a
mile
: Thursday, October 04, 2001 6:40 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Export - Import from Oracle v8 to v731
Hi christopher,
How i can make my orace8 server compatible with v731... is i can set any
init.ora parameter
or something different
Nirma
Title: Export - Import from Oracle v8 to v731
Hi gurus,
i need to transfer db design of a small application from oracle v8(winnt) to v731(vms=vax).
I successfully completed the export process:
c:\exp80 parfile=c:\exp_par.dat
exp_par.dat
---
userid=msalah/msalah@qtel
Title: Export - Import from Oracle v8 to v731
You generally cannot export from a higher level database to a lower. Although you can probably change the
compatible option to 7.3.4 and do it that way (from what I hear, never tried
it).
Do not criticize someone until you walked a
mile
To: Multiple recipients of list ORACLE-L
cspence [EMAIL PROTECTED]
@FuelSpot.comcc:
Subject: RE: Export - Import
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 Oracle
8.1.7 running
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 guess I have to get my hands
[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
If you have enough time for keeping your database down then as you said you
can experiment on it,cause the export import definetly takes time, it is
better to ship the files and bring up the database.
Recently I had an issue of moving a database from NT TO unix that too from
7.3.4 to 8.1.7
then as you said you
can experiment on it,cause the export import definetly takes time, it is
better to ship the files and bring up the database.
Recently I had an issue of moving a database from NT TO unix that too from
7.3.4 to 8.1.7,Man it was too slow.If the database files were portable
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
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 Oracle
8.1.7
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
to move my live database to another
server. From reading the fine manuals and from posts that I have seen I
have decided to use the export/import utility to make my move. My database
is inactive for the weekend. What I am not sure of is this, on my current
live database my datafiles(.dbf) reside
://www.ud.com
Use spare CPU to assist in cancer research.
-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 04 September 2001 20:24
|I have a question about how the export/import utility works. My
situation
|is that damagement had me put my live and test
1 - 100 of 125 matches
Mail list logo
