Re: Moving Sequences Between Schemas

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