1 Reply Latest reply: Nov 29, 2012 11:06 AM by Niket Kumar RSS

    defalut tablespace "user" vs "system"

    947771
      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