]
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
Is any single table more than 2G ? If not, just break
up the export into individual schemas and/or tables.
For those tables that are more than 2G, you could
compress via a pipe - for NT might mean running export
over sqlnet from a unix box.
hth
connor
--- [EMAIL PROTECTED] wrote: Hi DBAs,
You could migrate the database to 8i, or you could use sql to split the
table into 2GB and do the export in pieces, or you could just shut the
database down and do a cold backup of the database, retaining any media
you need to reinstall Oracle 7. Make sure if you are in archivelog mode
that you
I've uses the UNIX split command successfully with Oracle 7.3.4:
# set maximum file size for each chunk of the export file
#
MAXFILESIZE=1500m
export MAXFILESIZE
#
# create filenames for the parts of the backup
#
FILENAME1=$BACKUP_DIR/exporthrprd1.dmp
FILENAME2=$BACKUP_DIR/exporthrprd2.dmp
You don't mention OS, but if it's a flavor of unix, you could probably
do:
mknod my_pipe p
exp file=my_pipe all other export options
split -b 2047m my_pipe exp.dmp
This will generate multiple files, 2.047 MB per file. They will be
named exp.dmpaa, exp.dmpab, exp.dmpac, etc,etc.
To import,
The migration to an Oracle8i database is not possible, b'cause, the package
using the database only support Oracle7. I will have problem if they decide
to reuse this product.
The coldbackup is the less demanding solution.
Thanks
-Original Message-
Sent: January 9, 2004 9:39 AM
To:
--- [EMAIL PROTECTED] wrote:
Hi DBAs,
Because of some requirements from one of our vendor,
we still have a
database running Oracle7.3.4 on WindowsNT and since
this package is no longer used, so we
want to export the content of this database.
The database is around 60G, one table is 55G.
Mark, Jolane
It's on WindowsNT, but I will install client7 on a Unix machine and I will
use the pipe.
Thank you
Luc
-Original Message-
Sent: January 9, 2004 10:01 AM
To: Multiple recipients of list ORACLE-L
You don't mention OS, but if it's a flavor of unix, you could probably
do:
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 would guess that you are using a later version
of exp on your client. ie. 9i exp
Or maybe even an 8.1.7 exp on your 8.1.5 database.
Not sure if that combination would cause problems, and
I have no way to test it.
Jared
On Tue, 2003-12-30 at 09:14, Hamid Alavi wrote:
Hi list,
I am trying
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
Read about transportable tablespaces. It works like this:
you export metadata, make a copy of the files in the place where the new database
can access them and import the metadata. There are many limitations and stipulations.
You really need to read the manual for this one. If you don't want to
Dear :All
Oh thank now i know where to dig the information, i
will try to read this manual, ... i bet it should have
take me some time :)
thank
Jkean
--- Mladen Gogala [EMAIL PROTECTED] wrote:
Read about transportable tablespaces. It works like
this:
you export metadata, make a copy of
Rhojel - I'm not sure if export gives you enough information. Usually the
reason to export is that if you can export, you have a good copy of the data
and you can breathe a little easier. But usually export will fail on the
first corrupt block. Your corrupt block may be an index block, so export
;-)
Best Regards
DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/05/2003 12:09 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Rhojel Echano/Manila/PH/SGS)
Subject:RE: Export table to determine extent
[EMAIL PROTECTED] exp system file=aud.dmp log=aud.log tables=user_logon_audit
query=\where trunc\(logon_time\) = to_date\(\'20031105\',\'mmdd\'\)\
Export: Release 9.2.0.2.0 - Production on Thu Nov 6 17:11:41 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Password:
As Raj already stated, a trunc will help.
Personally, I don't like implicit date conversions. eg. use to_date() to ensure
that the date format you are using will work.
HTH
Jared
Ehresmann, David [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/06/2003 01:54 PM
Please respond to ORACLE-L
Hi
Not sure what the original question was BUT the script offered splits
exports so you may be interested in a tool Kurt van Meerbeeck and
Kugendran Naidoo wrote called Ora*PePi availbale on sourceforge - the
description from there reads:
quote
Ora*PePi is a superset of the Oracle export/import
| dd of=wrkpipe
#
# clean up the import pipe
#
rm wrkpipe
From: Armstead, Michael A [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Export Split Script
Date: Wed, 16 May 2001 13:07:24 -0800
Rajaram,
Please give me details
$FILENAME2 $FILENAME3 | uncompress | dd of=wrkpipe
#
# clean up the import pipe
#
rm wrkpipe
From: Armstead, Michael A [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Export Split Script
Date: Wed, 16 May 2001 13:07:24
If you are using the BUFFER= parameter of the export, remove it and you
will see much improvement!
Carol
-Original Message-
Sent: Monday, September 08, 2003 2:44 PM
To: Multiple recipients of list ORACLE-L
Basic info:
- RAC 9.2.0.2,
- dual node Alhpa ES45 cluster,
- CPU @ 1GHZ, very
Thanks for answerring.
Command line is like exp system/... full=y log=... file=... statistics=none
compress=n.
Important points, once again:
- 8.1.7.0.0 exp with SAME database (9.2 was created with import of that
database) is faster,
- lots of cpu time is spent selecting EXU9RLS, EXU9SYN,
Ron
You could try getting the 7.3.4 export to run against the 8.1.7 database.
I don't know if the 32 vs 64 bit would affect you. Also, datafile formats
changed between Oracle 7 and 8 and I haven't tried this particular export.
Maybe somebody on the list has.
Dennis Williams
DBA, 80%OCP, 100%
Smith, Ron L. wrote:
I need to export the data from an Oracle 8.1.7 database HPUX 64 and
import it back into an old 7.3.4 HPUX 32 database.
The 7.3.4 import doesn't like the 8.1.7 export file.
Any ideas?
Ron Smith
I am unsure whether a 7.3.4 client can talk to a 8.1.7 database. It
Ron,
Something I forgot and which Dennis' remark about format reminded me
of :
You'll probably have to run $ORACLE_HOME/rdbms/admin/catexp7.sql againts
your 8.1.7 database before you can use the Oracle7 exp against it (and
run catexp again once you're done). File formats should be OK if your
If 8.1.7 is production, then I would use selects, sql loader. If you are
REAL industrious, you can try exp with 8.1.7 exp, then imp with show=y to
generate a big nasty mess of text that you can try whipping up on with sed
and/or awk to clean up.
If 8.1.7 is a slam and bang around database, it
I don't know the answer for sure, but can hazard a guess. :-)
65535 is typically the maximum number of bytes that can be written with
a single write() system call. If you use a shorter record length,
you'll execute multiple write()'s for each 64K of data, which involves
multiple trips through
Hi,
I can't speculate as to why the export dies, but you can correct the
direct=y character set error by setting the NLS_LANG variable in your user
profile to whatever character set it is trying to export from.
--
Joe Frohne
Rawson Oaks Consulting
http://www.rawsonoaks.com
[EMAIL PROTECTED] or
if you are talking about dbase files you can do it via Excel.
Excel has drivers both for oracle and for dbase files.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 7:43 AM
Hello,
I can't find out how
What type of file is 'dbf'?
Sergey V Dolgov [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/05/2003 09:43 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Export data to dbf
Hello,
I can't find
9M is not a large shared pool. What db version? What app? We really
do need some details to provide intelligent responces. You might
consider bumping it to 20M and see what happens. Without more
information it is impossible to be more specific.
Allan
-Original Message-
Sent: Monday,
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
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
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
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
Hi
Is it possible you FTP'd the export file across to the new machine in ASCII
mode (the default on win systems)? Always ensure you use BINARY mode - the
stray LF's get substituted by CRLF's inside the export file and it really
messes up the internals and can sometimes the imp utility to skip to
Thanx guys for all your guidance.
Thanx Kirti.
i found that an index on table 17 caused all the delay and took a
long time to be created.
when i said
IMP FILE=ABC.DAT INDEXES=N ROWS=Y
i was able to get all the tables.
but still,while importing i get the error
IMP-00019: row rejected due to
Thanx guys for all your guidance.
Dale,
i found that an index on table 17 caused all the delay and took a
long time to be created.
when i said
IMP FILE=ABC.DAT INDEXES=N ROWS=Y
i was able to get all the tables.
but still,while importing i get the error
IMP-00019: row rejected due to ORACLE
Thanx guys for all your guidance.
Thanx Adar.
i found that an index on table 17 caused all the delay and took a
long time to be created.
when i said
IMP FILE=ABC.DAT INDEXES=N ROWS=Y
i was able to get all the tables.
but still,while importing i get the error
IMP-00019: row rejected due to
Why are you sending it repeatedy? or is there a virus?
Regards
Naveen
-Original Message-
Sent: Wednesday, December 18, 2002 3:49 PM
To: Multiple recipients of list ORACLE-L
Thanx guys for all your guidance.
Thanx Adar.
i found that an index on table 17 caused all the delay and took a
oraora - I doubt that Import did insert that record. The message says it
skipped that record. Check the table to see whether it was inserted. What
did you set for the parameter IGNORE?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday,
oraora,
Did the original export come from a database that you have access to?
Check the description on the table that had failed to insert some rows.
The original source table has different sizes on the columns than the
tables you are importing into, That is why some records are getting
rejected
Hi Walid
Do you know the Oracle Migration Workbench?
We did the same migration(informix to oracle) using thats tool.
Adriano Freire.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 17, 2002 9:23 AM
Hi List ,
Can you help
]
Sent by: cc:
[EMAIL PROTECTED] Subject: Re: Export From INformix
running on unix
:
[EMAIL PROTECTED] Subject: Re: Export From
INformix running on unix
12/17/2002 04:49
PM
Please respond to
ORACLE-L
Hi Walid
Do you know the Oracle
Do you have COMMIT=Y? Drop the indexes first and then import. Then create
the indexes.
-Original Message-
Sent: Monday, December 16, 2002 8:34 PM
To: Multiple recipients of list ORACLE-L
Are you importing indexes?
How many indexes there are on table #17?
Is the DB in archive log
Are you importing indexes?
How many indexes there are on table #17?
Is the DB in archive log mode?
Is the archiver getting stuck?
- Kirti
-Original Message-
Sent: Monday, December 16, 2002 8:29 PM
To: Multiple recipients of list ORACLE-L
guys,
i am exporting a DB of size 10G.
it
Hello
After building a table the import builds constraint and indexes.
If you got a big table that can take awhile.
Check with task/performance monitor if the instance is idle or working.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
David:
You always want to use the older export utility when exporting from an older DB version, and use the new import untility to import into the newer database.
To export from an 8.1.7 database, use the export utility from the version 7 database and export using a link to the new database (exp
Title: RE: Export from Oracle 8 to Oracle 7
Just use an Oracle7 client to do the exp
-Original Message-
From: Bartolo, David [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L
Subject: Export from Oracle 8 to Oracle 7
Title: RE: export in full mode but exclude particular user?
anybody know the views for 9.2?
-Original Message-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 20, 2002 10:58 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: export in full mode
Title: RE: export in full mode but exclude particular user?
It's the same - exu81obj and exu8usr.
HTH
Arup Nanda
www.proligence.com
- Original Message -
From:
Chris
Stephens
To: Multiple recipients of list ORACLE-L
Sent: Thursday, November 21, 2002 9:18
AM
Title: RE: export in full mode but exclude particular user?
i'm 99% sure that can't be done. you'll have to explicitly name all the other users with owner=user_a,user_b,... ...then you can do an import with full=y ...or flip/flop by full=y on export and owner=.. on the import.
...first
in the past there was a way described here on the list, TOTALLY
UNSUPPORTED by tweaking one of the underlying views.
joe
Chris Stephens wrote:
i'm 99% sure that can't be done. you'll have to explicitly name all
the other users with owner=user_a,user_b,... ...then you can do an
import with
Joe,
It may be unsupported, but it does work. One must be careful in saving the original
catexp.sql, and running it afterwards (after the 'tweaked' export is done). I have
been using this 'tweak' for quite some time.
Excluding user(s) from export is a fairly easy tweak.
Oracle already
Thanks Kirti ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is
Raj,
The answer is: Yes.
You will need to edit catexp.sql to rebuild internal view to exclude
interested owner#.
This is as simple as it gets!
- Kirti
-Original Message-
Sent: Thursday, September 05, 2002 8:43 AM
To: Multiple recipients of list ORACLE-L
Is it possible to exclude
Raj - Assuming you are using an export parameter file (file.prms). Instead
of the FULL=Y parameter, use OWNER=(USER1,USER2,USER3, . . .
Unfortunately export doesn't offer the capability to say full except for
mdsys, ctxsys, if that is your question. You can also do a full export and
then
Title: RE: Export question on excluding certain schema
Dennis,
I received a reply from Kirti that by tweaking catexp81.sql file we could just achieve that. This is possible because all we have to do is tweak a view that dictates what will be exported.
It looks like that will solve my
Raj - Great! That one is beyond me, but Kirti is certainly the expert, so
were I you, I'd try his suggestion. Good luck.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, September 05, 2002 10:23 AM
To: Multiple recipients of list ORACLE-L
NO! NO! NO! Please... I am not an expert.
I just remembered this trick that I learned from the real experts (like
Anjo, X$KGopal ...)
I simply passed on what I had learned from others.
Cheers!
- Kirti
-Original Message-
Sent: Thursday, September 05, 2002 12:08 PM
To: Multiple
Title: RE: Export question on excluding certain schema
Also, by default, in Oracle 8.1.6 MDSYS and CTXSYS are already excluded from the export, so no editing of catexp.sql is needed to do what the original poster wanted to do.
# grep MDSYS $ORACLE_HOME/rdbms/admin/catexp.sql
u$.name
Title: RE: Export question on excluding certain schema
Thanks
for the info. Learned something new.
Dennis
: That proves I am no expert ;)
-
Kirti
-Original Message-From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]]Sent: Thursday, September 05, 2002
2:29 PMTo: Multiple
Title: RE: Export question on excluding certain schema
Missed that too ...
Thanks Jacques
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
Any opinion expressed here is
personal and doesn't reflect
Someone at the customer site dropped the table between the time when
I ran the export and when I looked at the dictionary views.
Waleed, I tried your suggestions. Thank you very much for the
help and information.
Kay Miller
-Original Message-
Sent: Thursday, August 22, 2002 4:38 PM
One option is to create a special user for exports,
and create a logon trigger for that user which does
alter session set optimizer_mode = ...
hth
connor
--- Ed Lewis [EMAIL PROTECTED] wrote: Hello,
We have the optimizer mode set to first rows
on our (25gb) database to meet a vendor
PROTECTED]
-Original Message-
Sent: Thursday, August 15, 2002 10:23 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: export with first rows
The export views created by the catexp script
are totally screwed if you have FIRST_ROWS
as your optimizer setting.
Either use
Will it work without volsize parameter? I am producing one more par file for
Pawan's reference
userid=system/password
full=y
log=/u100/app/oracle/local/dba/fullexp/log/filename.log
file=/dev/tape --Ask your Unix admin for configured tape device
#file=/dev/rmt/0m
#volsize=16384M
volsize=0
It
looks like you have very high water marks and/or high fragmented
segments
Waleed
-Original Message-From: Ed Lewis
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 15, 2002 5:14
PMTo: Multiple recipients of list ORACLE-LSubject:
export with "first rows"
Hello,
We
ALL_ROWS and FIRST_ROWS have serious problems when
querying the data dictionary in all versions of Oracle from v7.x to v8.1.x (see
previous posting on 10-Aug, subject "Re: OPTIMIZER_MODE recommendation for
9.2"), documented in bug #564434. The situation is finally fixed in 9iR2,
and
Ed,
FIRST_ROWS optimizes for 'best response', and the default CHOOSE would have
used 'ALL_ROWS' for 'best throughput'. I have never run a Db in 'FIRST_ROWS'
- probably because it would always favor NLs over HJs and have a host of
other issues. You should _never_ analyze SYS objects - you will
The export views created by the catexp script
are totally screwed if you have FIRST_ROWS
as your optimizer setting.
Either use CHOOSE or edit the views to include
a RULE hint on all SELECT statements
and you'll be fine.
And if you tell Oracle support I recommended you did
this, I'll personally
Parfile export.par:
*
file=/dev/rmt0
buffer=10485760
full=yes
statistics=none
log=/tmp/export.log
*
exp system/change_on_install parfile=export.par
On 2002.08.16 01:08 Pawan
C:\EXP SCOTT/TIGER TABLES=EMP QUERY='WHERE JOB IN (''MANAGER'')'
THIS WORKS FINE...
hth.
nIRMAL
(oCP?).
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 9:53 AM
To: Multiple recipients of list ORACLE-L
the following syntax gives invalid col name :
exp
Title: RE: Export syntax
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: lundi, 22. juillet 2002 23:53
To: Multiple recipients of list ORACLE-L
Subject: Export syntax
the following syntax gives invalid col name :
exp test/test file=expt.dmp
BDY.RTF
Description: RTF file
Did you run catalog.sql which calls catexp.sql?
Sanjay
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: 23 July, 2002 4:53 PM
To: Multiple recipients of list ORACLE-L
Oracle Version: 8.1.7
OS : Sun Solaris
Shell: ksh
the following syntax gives invalid col name :
exp
Hi,
Check out Bug 1575222 in metalink (someone sent it to me).
Exact bug. Suppossedly fixed in 8.1.7.2 Will test with my 8.1.7.3 version.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services--
Title: RE: EXPORT BUG: oncorrect storage parameters being produced RESOLVED new bug
Hi,
Check out Bug 1575222 in metalink (someone sent it to me).
Exact bug. Suppoesedly fised in 8.1.7.2
-Original Message-
From: Patricia Karla Cordeiro [EMAIL PROTECTED]@SUNGARD
Sent
[EMAIL PROTECTED] wrote:
Hi!
Can I export a 7.3.3 database with a 8.1.7 export utility? Theoretically
it should work.
EXP-8: ORACLE error 942 encountered
ORA-00942: Tabelle oder View nicht vorhanden
EXP-00024: Export views not installed, please notify your DBA
EXP-0: Export
But why would you want to?
If you export using the 7.3.3 database using the 7.3.3 export utility you
should be able to import it into your 8.1.7 database using the 8.1.7 import
utility. It's backward compatible.
You just can't go the other way (import an 8.1.7 export to 7.3.3).
Jay Miller
Ron,
I'm doing the same thing; full export from 7.3.4, full import into 8.1.7.3.
I used the 7.3.4 export binary and the 8.1.7 import binary. No complaints
about different versions.
Mark Stahlke
DuhBA
Denver Newspaper Agency
-Original Message-
From: Smith, Ron L.
Thanks!
-Original Message-
Sent: Tuesday, May 21, 2002 3:27 PM
To: Multiple recipients of list ORACLE-L
Ron,
I'm doing the same thing; full export from 7.3.4, full import into 8.1.7.3.
I used the 7.3.4 export binary and the 8.1.7 import binary. No complaints
about different versions.
Ron - Just don't try to import the system objects into your new database.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, May 21, 2002 3:00 PM
To: Multiple recipients of list ORACLE-L
I need a full export of a 7.3.4 database that will be
Title: RE: Export multiple targets using OEM
I am using OEM 9.0.1 with job scheduler
I am trying to export full database for multiple targets using the job scheduler.
How do you specify more than one .dmp name and location? I want a .dmp and .log file for each target.
Even though I
Title: RE: Export multiple targets using OEM
It is
not possible to have to seperate export jobs running thro oem until and unless u
do it thro node jobs where in u can call the export command and tell the export
command to use a parfile which u keep it in the os in this parfileu
can specify
There are two ways ..
1. Use Procedural Gateways to get at SQL Server Tables thru Oracle and do a
CTAS.
2. Bring the data onto a Flat file using the export utility in SQL Serer and
upload to Oracle using SQL Loader.
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4)
1 - 100 of 320 matches
Mail list logo