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

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.

It's impossible.

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

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

Quote:

---

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

---

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

Quote:

---

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

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

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.

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

Sanjay

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

Thanks lot