Copy a schema

[athom]

Hy,

Do you know how copy a user...

Like COPY USER TO USER2

With his schema off course..

Thanks a lot


Athom

 

[THoey]

The only way I can think of is using Oracle 8.1.7 is DBA Studio. Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[Turkbear]

You can EXPORT ( in USER mode) USER's objects and then
create ( if not already done) USER2 and
IMPORT with the FROMUSER=USER and TOUSER=USER2
parameters set...( you will need to have DBA privs)

 

[athom]

thanks a lot, i love oracle, all it's possible...

 

[THoey]

Doh... I knew that... Good catch Turk... Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...