Copy of a schema?

Hello

I am using Oracle 9i on Windows 2000.

I have a user account which name is "A", it has 10 tables. I want to create another user account "B". Is here any query to create a user account "B" which suould be the same copy of the existing user account "A" ( I mean the old user account's tables should be created in the new user account ).

Thanks.
Namet ullah kalair

Quote:

---

Originally posted by nametullah
Hello

I am using Oracle 9i on Windows 2000.

I have a user account which name is "A", it has 10 tables. I want to create another user account "B". Is here any query to create a user account "B" which suould be the same copy of the existing user account "A" ( I mean the old user account's tables should be created in the new user account ).

Thanks.
Namet ullah kalair

---

export/import fromuser touser

It means no query available to do this job???

Namet ullah kalair

What do u mean by query?
Sanjay clearly told what u have to do.See the post of Psoni.

Create table as ....

Is here any query like

Create user as ...

no such SQL exists