Re: "create sequence" statement and 'starting with' clause issue

DA Morgan ha wrote:

> You still seem to be under the impression that there is a relationship
> between a table and a sequence. No such relationship exists: They are
> totally independent objects.

Yes, i know that.
This is the reason why the sequence is not present in the dump i have. My client will upload a dump in a specified folder (net protection issue) w/o any other objects but a single table. I've to import it in a tablepsace where such table do not exist. After importing, i need to create a sequence with the value starting from the max+1 of the table like you guess (counter like problem).

Now, thanks to "execute immediate" pl/sql clause, all works.  

termoPilucco Received on Tue Nov 21 2006 - 10:41:56 CST