CREATE SCHEMA! HELP! [message #68670] |
Mon, 07 June 2004 06:54 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Milly
Messages: 72 Registered: March 2004
|
Member |
|
|
hi all!!
I have forgot HOW CREATE a new schema!!
I've created a new User, a tablespace....but now???
I'm using DBA Studio 8...
any idea??
thanks!
|
|
|
Re: CREATE SCHEMA! HELP! [message #68676 is a reply to message #68670] |
Fri, 11 June 2004 06:44 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Frank Naude
Messages: 4580 Registered: April 1998
|
Senior Member |
|
|
Hi,
A schema is a user + objects. So, you can do a "create user..." and then create your tables, indexes, etc. or use the "create schema" command to do them all as one statement.
For more info, see the SQL Reference guide.
Best regards.
Frank
|
|
|