DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SEQUENCE value after import not set

Hybrid View

  1. #1
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132

    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

  2. #2
    Join Date
    Feb 2003
    Location
    London
    Posts
    170
    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
  •  


Click Here to Expand Forum to Full Width