Re: Duplicate Database?

I have had similar problems, losing permissions on export/import.

1. Create your users on the target environment.
2. Create all your objects on the target database using a DDL script.
3. Explicitly set permissions for roles, schemas, etc.
4. Truncate all the target objects.
5. Perform your import.

BTW, make sure you are exporting with permissions.

Good Luck,
Christopher Weiss
Professional Services Division
Compuware Corporation

Ken Rachynski <krachyn_at_cadvision.com> wrote in message news:37b1a1ac.8116372_at_news.cadvision.com...
> Good day,
>
> I'm having some difficulty duplicating my database so I can copy my
> development system into production. I used OEM to export my full
> database, created a new database with similar parameters to my
> development system and tried to import the database using the same
> account that I had exported my database with. I get permission errors
> for the most part indicating that account can't create some of the
> schemas in the database.
>
> Can somebody offer tips for doing this or point me in the direction of
> some good notes?
>
> Thanks in advance,
> Ken
Received on Wed Aug 11 1999 - 12:18:42 CDT