This discussion is archived
1 Reply Latest reply: Nov 29, 2012 9:06 AM by Niket Kumar RSS

defalut tablespace "user" vs "system"

947771 Newbie
Currently Being Moderated
Hi

while migrating to oracle from sqlserver 2005, i created users
using following query.

CREATE USER MWREP
IDENTIFIED BY mwrep
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP;
GRANT CONNECT, RESOURCE, CREATE SESSION, CREATE VIEW TO MWREP;

after migration i created a script of all objects using export wizard so that script can be run on any new shecma, to create all objects.

1) my problem is to create new schema. can i use the above default tablespace "user".
or should i use "system". becasue when i create new user using graphical user interface in otherusers node of sys.
it creates users with tablespace as "system".

2) and please also tel me what is the diffrence , if i keep default tablespace "users" when compaired to "system".


yours sincerely.

Edited by: 944768 on Nov 29, 2012 8:13 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points