| Importing & Export [message #54108] |
Wed, 30 October 2002 01:48  |
Suraj
Messages: 38
Registered: April 2002
|
Member |
|
|
I have got two (2) servers with similar installations as follows:
O/S: HP Unix
Oracle 8i and business application.
I have problem importing the full database made from box 1 onto box 2.
I used the following parameters for the import but I still get Constraints violation errors.
Ignore = Y
Grants=Y
Indexes=Y
full=Y
destroy=Y
Can anybody give me a hint?
|
|
|
|
| Re: Importing & Export [message #54110 is a reply to message #54108] |
Wed, 30 October 2002 02:32  |
SureshB
Messages: 7
Registered: June 2002
|
Junior Member |
|
|
|
Box2 already have the system and sys schema. While importing from box1 to box2 the constraints of these schemas are violated. Ignore the error messages belonging to system and sys.
|
|
|
|
|
|
| Re: Importing & Export [message #54119 is a reply to message #54108] |
Wed, 30 October 2002 17:13 |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
When exporting setup, constraints=n, rows=y. That will make one set w/o the constraints. Then do one more export with rows=n, contstrainst=y. Run that dump file after the first one with ignore=y.
That should take care of the constraints.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
