| Problem with Export (Oracle 9.2.0.1.0) [message #73520] |
Fri, 14 May 2004 03:50  |
Fanko
Messages: 1
Registered: May 2004
|
Junior Member |
|
|
Hi
I am trying to take full export for database and getting "EXP-00008" error:
EXP system/manager@database PARFILE='exp_parfile.txt'
Export: Release 9.2.0.1.0 - Production on Fri May 14 14:42:21 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 6552 encountered
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-553: character set name is not recognized
EXP-00000: Export terminated unsuccessfully
Could you please help me to resolve this issue?
Thanks in advance !
Fanko
|
|
|
|
|
|
| Re: Problem with Export (Oracle 9.2.0.1.0) [message #73529 is a reply to message #73520] |
Mon, 17 May 2004 07:10  |
Keith Sandberg
Messages: 4
Registered: May 2004
|
Junior Member |
|
|
Before I did the import, I was running a script (in effect) that would create all my objects in the target database first.... I did this because my tablespace names are different in 9i, and I wanted to ensure that my tables and indexes are in the right place. The tablespaces are LMT... the tables and indexes are all created with an initial extent equal to their current size... so I know space management is not the problem.
Some of my tables have constraints and triggers. My script was creating these objects, then disabling them. However, it appears that the IMPORT was applying the triggers and constraints anyway.
This morning, I created all my objects, as normal, except for the constraints and triggers. My IMPORT is blazing away.... I've already loaded over 3GB in about 90 minutes... it looks like my total load is gonna be about 3 hours. It was taking 12 hours. Very cool!
Should I assume that it is good practice, in my case, to disable all my constraints and triggers in the source database first, BEFORE I do an export??? SO that the IMPORT does not use the triggers when importing?
|
|
|
|
|
|
|
|
| Connecting (Oracle 9.2.0.1.0) with php php-oci8.dll not found error [message #73617 is a reply to message #73529] |
Wed, 02 June 2004 21:31 |
Faisal Ameer
Messages: 1
Registered: June 2004
|
Junior Member |
|
|
I have developed an application using php 4x and oracle 9i 9.0.1.1 and Appache server on windows 2000 but
my client wants me to put my application on IIS 6.0 on Windows 2003 Server and oracle 9.2.0.1.0 now i have configured IIS for php as phpinfo(); is working fine but now phpinfo(); is not recognizing the php_oci8.dll it gives a n error message
If any one can help me on that I'll be really obliged
Thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
