| Export Error [message #133615] |
Sat, 20 August 2005 02:12  |
benet_j_p
Messages: 1
Registered: August 2005
Location: Mangalore
|
Junior Member |
|
|
We have OS
SCO OpenServer(TM) Release 5
and oracle
Oracle7 Server Release 7.3.4.0.0 - Production
PL/SQL Release 2.3.4.0.0 - Production
CORE Version 3.5.4.0.0 - Production
TNS for SCO System V/386: Version 2.3.4.0.0 - Production
NLSRTL Version 3.2.4.0.0 – Production
.Export: Release 7.3.4.0.0 - Production on Sat Aug 20 10:13:07 2005
Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
We are using above versions and it exporting without error. But from last few days when we are exporting, we are getting following error at the end.
. exporting tables……
. exporting synonyms
. exporting views
EXP-00008: ORACLE error 1436 encountered
ORA-01436: CONNECT BY loop in user data
EXP-00000: Export terminated unsuccessfully
When we are importing with above dmp file it is not importing correctly.
We are done following excesses
1. We are having 3 users (say A, B, C) other than System and Sys. If you delete A user’s views and exporting only A user, than it is exporting correctly without error. But once again if we created one view for A user and exporting, same error will come. (It is same for all other users)
2. We are taken the script of views of A, B, C users (say abcviews.sql) and deleted all views (including system) except sys user and exported the entire database using system user. It is exported correctly without error (say entdb.dmp). And we are created new database and imported the above dmp file (say entdb.dmp) and it will imported correctly without error (we are taken care of datafile name with old name and all). And finally run the same script (i.e. say abcviews.sql). Now we are tested for exporting and found that it exported without errors.
Now you please suggest any other solutions to solve the above problem without creating new database.
|
|
|
|
| Re: Export Error [message #133629 is a reply to message #133615] |
Sat, 20 August 2005 05:40  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Are there different version of databases involved here?
Does Your target database (which you are exporting) and the client installation from which you initiate the export differe in versions?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
