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 ).

Namet ullah kalair