Hi, Just a correction on my last mail; I wrote >>>the following In Oracle >>>Update sequencename set next_value=xxxx I got that idea from a web page but it's wrong.sorry abt that:-(
one solution in oracle(and this time tested!!!:-)) is: Alter sequence sequencename increment by suitableincrementvalue; Select sequence.nextval from dual; Alter sequence sequencename increment by 1; Well it no where near as elegant as PostgreSQL's setval.:-) And unfortunately alter sequence does not work in SAPDB ORACLE MODE. I need this functionality as Setting a value of a sequence is necessary when importing data into tables that use a sequence for its PK. I'm trying to automate it such that I can set the sequence nextvalue to the maxval of the PK column +1 using SQL statements. Regards, Ajit _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
