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".
Edited by: 944768 on Nov 29, 2012 8:13 AM