| import database error [message #319335] |
Fri, 09 May 2008 22:12  |
rushing
Messages: 135
Registered: January 2004
Location: Beijing,China
|
Senior Member |
|
|
When I import all database , there is some error , such as the user has existed.
If I import a table , it is OK. But the sequence value could not be restored.
How to do?
Thanks!
|
|
|
|
|
|
| Re: import database error [message #319337 is a reply to message #319335] |
Fri, 09 May 2008 22:37  |
TheSingerman
Messages: 49
Registered: April 2008
Location: Brighton, Michigan
|
Member |
|
|
More specifically:
A sequence is a sequence is a sequence. It has a life of its own. It has no intrinsic attachment to anything else. Your application may choose to use it when populating a table, but there is nothing preventing someone from using some other sequence -- or no sequence at all.
When you export a schema, the DDL to create the sequences, in their current state, gets created and placed in the .dmp file. If you look closely at the messages during export and import, you will notice that the sequences get exported and imported in one group, and not as part of any table operation.
So, if all you do is import a table, all you do is import the table. To import a sequence, you must do at least a user level import.
|
|
|
|
| Re: import database error [message #319647 is a reply to message #319335] |
Mon, 12 May 2008 08:29 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
| rushing wrote on Fri, 09 May 2008 23:12 | When I import all database , there is some error , such as the user has existed.
|
Then use should be using IGNORE=Y
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
