Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: "create sequence" statement and 'starting with' clause issue

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

From: Ed Prochak <edprochak_at_gmail.com>
Date: 21 Nov 2006 09:45:04 -0800
Message-ID: <1164131104.577046.108020@m73g2000cwd.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US