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!

Report message to a moderator

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: 4581
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

Report message to a moderator

Previous Topic: How to Import data from higher version to lower version and vice versae?
Next Topic: jobs stored where?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 20:45:49 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.