Home » SQL & PL/SQL » SQL & PL/SQL » where are the tables get created by default
where are the tables get created by default [message #19965] Mon, 22 April 2002 02:00 Go to next message
ksr
Messages: 112
Registered: January 2002
Senior Member
Hi,
1 have 2 questions

1) In which tablespace has the users have to be created
2) In which tablespace will all the tables,procedures,temporary tables and packages would be created for a particular user.

suppose the new user(test) is created in tablespace users.So where will be the tables,packages and procedures will be created for that user.

Are they any documents for this.

any help is appreciated.

sk

Report message to a moderator

Re: where are the tables get created by default [message #19966 is a reply to message #19965] Mon, 22 April 2002 02:21 Go to previous message
Epe
Messages: 99
Registered: March 2002
Member
Hello,

by user creation you have to give a default tablespace for that user. If you don't, then the system tablespace is used.
For more info about user creation see on-line Oracle Manuals on :
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76956/users.htm#790
Go to "Oracle Users" and then "Creating users".

Success,

epe

Report message to a moderator

Previous Topic: How to tune SQL query
Next Topic: Can you pls give sql query for a little complex functionality
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 22:37:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.