How to copy the tables of one user to another in the same schema

[venkateskg]

Hi,

I want to copy the tables of one user in the schema to another user in the same schema. How do i can achive this.

thanx in advance.

[Shestakov]

It's impossible.

Owner(schema name) = user (username)!!!

[venkateskg]

Hi I didn't get u , what do u mean to say....

[SANJAY_G]

Hi I didn't get u , what do u mean to say....

I too didn't get what do you mean by this..

I want to copy the tables of one user in the schema to another user in the same schema. How do i can achive this.

Sanjay

[pando]

an user is a schema, a schema is an user so noone understand what do you mean by another user in same schema since there is only one user per schema

[venkateskg]

I have one database. In that db, there are two users. I want to copy one user table(or objects) to another user in the same database. this is what i meant.

[SANJAY_G]

OK. Now its clear.
The easiest way is EXPORT/IMPORT
using FROMUSER TOUSER

Sanjay

[pando]

if it´s one table then use create table as select

[venkateskg]

Thanks lot