How to create default tables in a new user

[venku72]

Hi

I am new to oracle. I create a new user in the data base and I want to create all the default tables (which are there in default user SCOTT/TIGER) in my new user.

Is ther any command that i can give to create all the tables with default data in my new user?

thx..
venkuu72

 

[SantaMufasa]

Yes, Venku, there are several methods to build the SCOTT/TIGER tables in your new user. After you have created the new user, log into SQL*Plus as the new user then use this model:

CREATE TABLE EMP AS SELECT * FROM SCOTT.EMP;
CREATE TABLE DEPT AS SELECT * FROM SCOTT.DEPT;
et cetera

Let us know if this works to your satisfaction.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]