The plsql user is created using the USERS and TEMP tablespace. : Table space « Table « Oracle PL / SQL






The plsql user is created using the USERS and TEMP tablespace.

  
SQL>
SQL> DEF username = plsql
SQL> DEF default_ts = USERS
SQL> DEF temp_ts = TEMP
SQL>
SQL> SET FEEDBACK OFF SERVEROUTPUT ON VERIFY OFF TERMOUT OFF
SQL>
SQL> SPOOL create_user.log
SQL>
SQL> DECLARE
  2     v_count       INTEGER        := 0;
  3     v_statement   VARCHAR2 (500);
  4  BEGIN
  5
  6    
  7
  8     v_statement := 'CREATE USER &username IDENTIFIED BY oracle'
  9        || ' DEFAULT TABLESPACE &default_ts'
 10        || ' TEMPORARY TABLESPACE &temp_ts'
 11        || ' QUOTA UNLIMITED ON &default_ts'
 12        || ' ACCOUNT UNLOCK';
 13
 14     EXECUTE IMMEDIATE (v_statement);
 15
 16     
 17     EXECUTE IMMEDIATE ('GRANT connect, resource TO &username');
 18     EXECUTE IMMEDIATE ('GRANT CTXAPP TO &username');
 19
 20     DBMS_OUTPUT.put_line ('  ');
 21     DBMS_OUTPUT.put_line ('User &username created successfully');
 22     DBMS_OUTPUT.put_line ('  ');
 23
 24  EXCEPTION
 25     WHEN OTHERS
 26     THEN
 27        DBMS_OUTPUT.put_line (SQLERRM);
 28        DBMS_OUTPUT.put_line ('   ');
 29  END;
 30  /
User plsql created successfully
SQL>
SQL> SET FEEDBACK ON TERMOUT ON
SQL>
SQL>
SQL> SPOOL OFF
SQL>
SQL>

   
    
  








Related examples in the same category

1.Change user default table space and temporary table space
2.Get default table space for current user
3.Moving Tables To New Tablespaces or Storage
4.heap table
5.Show_space
6.Check space with show_space for an index with compress 1
7.Check space with show_space for an index with compress 2
8.Create two indexes on one table and check the space
9.alter tablespace
10.Map user objects to tablespaces.
11.Measure the fragmentation of free space in all of the tablespaces in a database