Home » RDBMS Server » Enterprise Manager » CREATE SCHEMA! HELP!
CREATE SCHEMA! HELP! [message #68670] Mon, 07 June 2004 06:54 Go to next message
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
Frank Naude
Messages: 4579
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
Previous Topic: How to Import data from higher version to lower version and vice versae?
Next Topic: jobs stored where?
Goto Forum:
  


Current Time: Thu Mar 28 09:40:26 CDT 2024