-
SEQUENCE value after import not set
-- Thanks in Advance
hi
8.1.7 red hat advance server
I took a export of a user and imported successfully.
however the application has not generated new sequence no from backend. sequence has got imported.
In the DB, if i query SEQUENCES i can see sequence name has been created.
Have i missed out something to do for SEQUENCE after import.
--Gajanan
-
however the application has not generated new sequence no from backend. sequence has got imported.
Are you populating a column with the sequence? Why dont you check the column values and see.
you could also do a simple
select your_seq_name.nextval from dual and see the value that it holds and do an insert from sqlplus to see if the insert works
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|