ORACLE-L <[EMAIL PROTECTED]>
om> cc:
Sent by: S
ECTED]>To: Multiple recipients of
> list ORACLE-L <[EMAIL PROTECTED]>
> Sent by: cc:
>
Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED]Subject: RE: Export / Import Question
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, Ja
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 G
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 the
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
databas
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 ab
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 ex
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 will
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 dump file. Then make sure all objects are dropped. [EMAIL PROTECTED] wrote:
I am 100% positive . I tried this process 2-3 times using di
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 showing
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 cons
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
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:
>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: Frida
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, w
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 som
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
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 proble
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 d
I just opened a low level TAR on these errors just to make sure my data is ok.
Thanks,
Dave
-Original Message-
Sent: Thursday, February 07, 2002 10:09 AM
To: Multiple recipients of list ORACLE-L
Quick look in Metalink would suggest that this is a bug, I would report this
to Oracle. I
Dave,
Everyone gets these same errors. If you are not using replication then do
not worry about these errors. If this is all you got then you are
probably good to go.
Rick
You have packages with status INVALID.
Correct them and the errors will go away.
Been there.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
> -Original Message-
> From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
> Sent: Thu, February 07, 2002 5:29 PM
> To: Multiple recipients
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 at the
v
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 i
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, Febr
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
dar, 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 on the sam
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.
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
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
For 8I : IMP SYSTEM/MANAGER@TEST file=path_to_your_dump_file/file_name.dmp
FULL=Y ...MORERead on the parameters.
I would drop all the users cascade( except sys,system,outln etc.) in the
test database prior to import. Don't bother using DESTROY. Everything will
go to where your TEST datafil
AIL PROTECTED]>
Subject: Re: export/import on the same
server
Sent by:
root@f
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 P
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
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)
Jac
: Multiple recipients of list ORACLE-LSubject:
RE: Export/Import Job
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
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
to know
about this for a testing scenario, this may be Ok, but not if you want the
Apps database to work from a logical point of view Nick, if you would to
like to follow this up, join the OAUGnet-DBA list at 'www.oaug.net' via the
Web ans search for the thread 'RE: expor
Chk the target database characterset.
--
On Wed, 17 Oct 2001 23:55:18
Sundar wrote:
>Hi All,
>
>I am trying to import an user from ORacle Ver 8.1.6 Running under Solaris and Oracle
>8.1.7 running under Windows NT. I want to export a user from Win Oracle to Solaris
>oracle and I am getting the
hu Kumaran[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: 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
Title: RE: Export - Import from Oracle v8 to v731
There is a compatible parameter for the
init.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 in
Title: 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,
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent
To: Multiple recipients of list ORACLE-L
@FuelSpot.comcc:
> Subject: RE: Export - Impo
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
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 PR
--
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
-
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 Hennema
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 Net
--
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
-
;Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients 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 L
Wow! Please elaborate!
> --
>
> From: "Jonathan Lewis" <[EMAIL PROTECTED]>
> Date: Tue, 4 Sep 2001 20:47:08 +0100
> Subject: Re: Export/Import question
[via ORACLE-L Digest -- Volume 2001, Number 248]
...
> If the tablesp
Dave,
Hopefully someone else already answered better, but if not,
it is the database alias in your connect string.
Wherever the database is for that alias is where the import will end
up.
Of course as with all things Oracle, it probably won't be quite that
simple, you may need to change netwo
database files were portable
> 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 <[EM
t;[EMAIL PROTECTED]>
>Subject: Re: 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 anot
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 mach
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 expo
rnsworth, 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 exp
.
>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,
&g
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 r
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 optio
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 COMP
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 tables
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 me
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, y
Thanks for the info. I looked at it, it's very informative.
>>> [EMAIL PROTECTED] 07/22/01 12:17PM >>>
Richard,
This is an issue with TYPE objects as the TOID (type
object ID) is exported (see the Utilities manual).
Also see Note: 1066139.6 "IMP-17 IMP-3 ORA-2304 IMP-63
FROMUSER/TOUSER Import
Richard,
This is an issue with TYPE objects as the TOID (type
object ID) is exported (see the Utilities manual).
Also see Note: 1066139.6 "IMP-17 IMP-3 ORA-2304 IMP-63
FROMUSER/TOUSER Import of Table With Object Column"
HTH,
-- Anita
--- Richard Ji <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I
Kevin,
Thanks for letting me know that I am not the only one had to
go throught this. :) Thank God I have VI editor, can't imagine
if I had to use notepad on windows to edit that file. There are
106 types!
Richard Ji
>>> [EMAIL PROTECTED] 07/11/01 01:15PM >>>
I've experienced and must admit t
I've experienced and must admit that it is a pain in the arse to deal with:)
KK
-Original Message-
Sent: Wednesday, July 11, 2001 12:41 PM
To: Multiple recipients of list ORACLE-L
Hi all,
I wonder if anyone has seen this before.
I export an user A, then import it into user B in a diff
look at the script
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2001 6:45 PM
> Is it possible to Export and Import Users definition including password .
>
> Here we have a production schema where we have created users to acce
Take a full export as system user from the source database and import into
the destination database. In this process all the new schema(users)along
with their privileges/roles should be loaded into the destination database.
Thanks,
Ashoke
>From: "Oracle DBA" <[EMAIL PROTECTED]>
>Reply-To: [EM
You can do that. Just make sure you FTP in binary mode. RBG
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 5:31 PM
> Can I import a database from NT which was
> exported from AIX RS6000 servers? Do I just
> move th
Joseph,
Following might help you.
We have databases 8.1.6 on Solaris 2.7. On NT4 we have 8.0.4. We export user
schema/tables from 816 and import the schema/tables into 804 on NT.
Important things are:
If your databases versions are same on both the machines, then use the same
exp/imp software
just move the expdat.dmp using a ftp binary data transfer and and use the
imp utility.
-Mandar
> -Original Message-
> From: Leyden, Joseph [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 07, 2001 4:32 PM
> To: Multiple recipients of list ORACLE-L
> Subject: export/import
>
>
> Can
Title: RE: export/import
> -Original Message-
> From: Leyden, Joseph [mailto:[EMAIL PROTECTED]]
> Sent: mercredi, 7. mars 2001 14:32
>
> Can I import a database from NT which was
> exported from AIX RS6000 servers? Do I just
> move the expdat.dmp (exported out
79 matches
Mail list logo
