ents of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Large Export Problem ..
FWIR, CVS doesn't handle binaries tho. We do the same thing for rdf's
(report files) and fmb's
(forms files) too.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new us
Subject: RE: Large
seems to be the right approach rather than importing the
> dump file and get a big list of errors.
>
> After seeing the responses from the list members, I got a clear idea how
to
> handle the
> "Large Export Problem". I will break up the export into 4 types(full
export
> w
26/2003 11:09 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Large Export Problem ..
I go even one step further here. Each object is required to have it's own
creation scrip
from the list members, I got a clear idea how to
handle the
"Large Export Problem". I will break up the export into 4 types(full export
with norows, static, non-static and the rest), schedule them to fit our
schedule, and use the version control system approach for the
packages/st
ECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: Large Export Pr
I export packages/stored procs and import to
> new DB if
> necessary?
> [4] Is there any other way to export the full database
> and eliminate the
> static partitions in a single step?
> [5] What is the best way to solve my export problem??
>
> Any ideas are appreci
Title: RE: Large Export Problem ..
Yes, that was a typographical error in my response. I meant IGNORE=N.
-Original Message-
From: Janardhana Babu Donga [mailto:[EMAIL PROTECTED]]
Jacques,
Your response is helpful. Thanks for your suggestions. I think I should import with
Title: RE: Large Export Problem ..
Jacques,
Your
response is helpful. Thanks for your suggestions. I think I should import with
IGNORE=N and not "Y". I think it is typo in your response. If not, please
clarify. I would utilize your script as an extra
precaution.
Thanks
Title: RE: Large Export Problem ..
(see comments below)
> -Original Message-
> From: Janardhana Babu Donga [mailto:[EMAIL PROTECTED]]
>
> Thanks for the caution. Does any one know if I export with
> owner=
> Name> rows=N, then drop a package and import
dependent.
Jared
Govindan K <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/25/2003 02:49 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: Large Export Problem ..
Babu
Why not t
PROTECTED]>
cc:
Subject: Re: Large Export Problem ..
Babu
Why not try 'direct=y' option. This has limitations
regarding the platform. Not 100% sure of it.
Check with Documentation. It does export very fast.
HTH
GovindanK
--- Janardhana Babu Donga <
ort to
> new DB if
> necessary?
> [4] Is there any other way to export the full database
> and eliminate the
> static partitions in a single step?
> [5] What is the best way to solve my export problem??
>
> Any ideas are appreciated.
>
> Thanks,
> -- Babu
>
_
to
> new DB if
> necessary?
> [4] Is there any other way to export the full database
> and eliminate the
> static partitions in a single step?
> [5] What is the best way to solve my export problem??
>
> Any ideas are appreciated.
>
> Thanks,
> -- Babu
>
_
ere any other way to export the full database and eliminate the
static partitions in a single step?
You'll need to list tables and omit certain tables.
You could export based on a SQL statement such that you omit the data
you don't want to export.
[5] What is the best way to solve m
static partitions in a single step?
You'll need to list tables and omit certain tables.
You could export based on a SQL statement such that you omit the data
you don't want to export.
[5] What is the best way to solve my export problem??
I think you're on the right track
er way to export the full database and eliminate
the
static partitions in a single step?
[5] What is the best way to solve my export problem??
Any ideas are appreciated.
Thanks,
-- Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Janardhana Babu Donga
INET: [EMAIL
export.
[5] What is the best way to solve my export problem??
I think you're on the right track.
You might also want to look at TRANSPORTABLE TABLESPACES.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, March 25, 2003 2:00
ay have to hardcode the table
> names.
>
> The database has lots of packages/stored procs which will be stored in
> the
> dictionary I believe.
>
> My questions are:
> [1] How can I reconstruct a database using this type of export if
> needed?
> [2] How can I
gain anything by using incremental export. Nightly loads will touch
every partitioned table and so incremental export will export the complete
tables and there won't be any difference between full export and incremental
export in this case.
I need additional help in resolving my large expo
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 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, Dece
Hello
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 back with the error Either Prefe
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
[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:
Title: Export problem
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
You should try changing the nls_lang value on the client to match the
server.
Rick
-Original Message-
Sent: Friday, November 30, 2001 8:10 AM
To: Multiple recipients of list ORACLE-L
Hi,
I am trying to export a data from server and getting following error
message:
EXP-00041: Exp
Hi,
I am trying to export a data from server and getting following error
message:
EXP-00041: Export done in server's WE8ISO8859P1, different from user's
character set US7ASCII
EXP-0: Export terminated unsuccessfully
How do I fix a problem.
My environment is SUN OS 5.6
t; > created. I am now performing an EXPORT of the
> > database and I am experiencing an EXPORT problem
> > that I have never encountered.
> >
> > Has anyone encountered this problem?
> >
> > EXP-8: ORACLE error 1008 encountered
> > ORA-01008: not a
has never been backed up since it was
> created. I am now performing an EXPORT of the
> database and I am experiencing an EXPORT problem
> that I have never encountered.
>
> Has anyone encountered this problem?
>
> EXP-8: ORACLE error 1008 encountered
> ORA-01008:
Title: UNIX help needed for sed multi-line pattern space
I have just started working at a company and the database has never been
backed up since it was created. I am now performing an EXPORT of the
database and I am experiencing an EXPORT problem that I have never
encountered.
Has
Do you have sysdba or sysoper privs and are you connecting to OEM with
sysdba/
Rick
-Original Message-
Sent: Wednesday, November 14, 2001 12:31 PM
To: Multiple recipients of list ORACLE-L
hi,gurus
help me ,in this problem
through command prompt i got export/import facility .bu
hi,gurus
help me ,in this problem
through command prompt i got export/import facility .but with same user (with all
permissions),i am not able to do same job.
error is:
The following error has occurred while trying to make the connection to the target
database using preferential cr
>From MetaLink
Error: EXP 41
Text: Export done in server's %s, different from user's character set %s
---
Cause: The specified NLS_LANG/NLS_NCHAR parameter is incompatible with the
value specified for the
Just set your NLS_LANG at a command prompt:. This is an example.
>NLS_LANG=American_America.US7ASCII
>export NLS_LANG
HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, August 31, 2001 12:23 PM
> Hi List,
>
> I have problem with
Hi List,
I have problem with export, when I try to run EXP got this error msg:
Any Idea ??
Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
EXP-00041: Export done in server's US7ASCII, different from user
Check out metalink, - its most probably mismatch
between export versions (and catexp in particular),
but there have been bugs in the past as well which
caused 904's...
hth
connor
--- Arslan Dar <[EMAIL PROTECTED]> wrote: >
> Hi there
>
> I am doing a USER LEVEL export as a user with
> EXP_FU
Title: EXPORT PROBLEM on 8.1.7
Hi there
I am doing a USER LEVEL export as a user with EXP_FULL_DATABASE role from oracle 8.1.6 HOST
using a remote machine (which have 8.1.7) through command line (EXP command).
i am getting following error
EXP-8 : Oracle error 904 encountered
ORA
MALA,
in the export log (typial) this is the order.
exporting job queues
exporting refresh groups and children
exporting user history table
exporting default and system auditing options
Export terminated successfully without warnings.
What you have to do is after importing you have to crea
.DBMS_IJOB", line 450
ORA-06512: at "SYS.DBMS_IJOB", line 482
ORA-06512: at line 1
EXP-0: Export terminated unsuccessfully"
Hope this you are looking for.
Thanks
-Mala
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L &
Mala,
Please don't jump into conclusion about the bug.I also made a mistake like
this before.What is the database version you are using.
If it is 8.1.6
can you please send your export script and your init.ora file so that i can do
something
Cheers
Ganti
--
Please see the official ORACLE-L FAQ
OTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re: EXPORT PROBLEM
> >Date: Wed, 28 Feb 2001 11:45:51 -0800
> >
> >Hi Mala,
> >If you're on 8.1.6 it's a bug. If you do your export without the
> >consistent pa
I am using 8.1.7.I think this is bug.What isur view
-Mala
>From: Rocky Welch <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: EXPORT PROBLEM
>Date: Wed, 28 Feb 2001 11:45:51 -0800
>
>Hi
Hi Mala,
If you're on 8.1.6 it's a bug. If you do your export without the
consistent parameter it should finish okay but you should patch your
current installation.
--- mala singh <[EMAIL PROTECTED]> wrote:
> Hi DBAs
>
> I have problem at time of full export of Database.The following are the
>
Have you run the catexp script as sys? It is in ORACLE_HOME/rdbms/admin.
If you have not run catalog run that first, then catproc and catexp.
If you have run the above, did you set your ORACLE_SID?
Just a thot,
rUTH
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EM
Hi DBAs
I have problem at time of full export of Database.The following are the
error message at end of full export.
EXP-8: ORACLE error 1403 encountered
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_IJOB", line 450
ORA-06512: at "SYS.DBMS_IJOB", line 482
ORA-06512: at line 1
EXP-0: E
46 matches
Mail list logo
