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

termoPilucco wrote:
> 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

So this was a one-time-only upload? I do not think I would bother writing a procedure in that case. I would just create the sequence myself manually.

Well you got it done. Have a good day.

   Ed Received on Tue Nov 21 2006 - 11:45:04 CST