Re: Moving Sequences Between Schemas

That's not really an option for me since our test instance runs on the same box as production. Path names, etc. can't be changed. I'm just wondering why the sequences are being imported. Anyone know if this behavior is different between Oracle 7 and 8? This particular client is running 7, but most of our client run 8. This client just happens to be the first where we are trying the new procedure.

TIA. "CHC" <qi.xiang.chi_at_icu.nl> wrote in message news:8kif5b$18a3$1_at_beast.euro.net...
> Eric,
> I'm daily refresh the test DB by copying the datafiles etc and create the
 DB
> on test machine.
> My DB is only 4GB big so it's quite easy to do. I don't know whether
> export/import is faster.
> After creating the DB on test machine I run a scripts to lock all users
 and
> create new one.
> This is to prevent that users accidental login to test machine.
> Maybe is copying and creating DB is a good alternative for you ??
>
> Rgrds, CHC
>
> Fender <nospam.efender_at_ix.netcom.com> wrote in message
> news:8khtj6$3kh$1_at_slb7.atl.mindspring.net...
> > In order to refresh our test environment, we do a full export of the
> > production environment and import into test using imp fromuser/touser.
> > Before running the import, we disable all triggers, truncate all tables
 and
> > drop all sequences. When performing the import, the production
 sequences
> > are NOT created in the test schema. Is there any way around this?
> >
> > Thanks,
> >
> > Eric
> > (remove nospam to reply via e-mail)
> > nospam.efender_at_ix.netcom.com
> >
> >
>
>
Received on Wed Jul 12 2000 - 00:00:00 CDT