RE: Creating new user

[Naveen Nahata]

SQL> CREATE USER <username> IDENTIFIED BY <password> [DEFAULT TABLESPACE <user_tablespace> TEMPORARY TABLESPACE <temp_tablespace>]

 

for importing on command prompt

 

imp username/password@database fromuser=<username> touser=<username> file=<export_dump_file>

 

If you just want the table structure and no data then use ROWS=N option too.

 

regards

Naveen

-----Original Message-----
From: Santosh Varma [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 22, 2002 5:14 PM
To: Multiple recipients of list ORACLE-L
Subject: Creating new user

how to create a new user ? in oracle 8.1.7 ?

and i want to import a dump file into that user so that i could create the tables. How to acheive this ?

 

any help will be appreciated.

Thanks and regards,

Santosh