Saturday, June 11, 2005

Oracle DBA for Dummy

Note to myself: set up Oracle user.

renegade:~ oracle$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.1.0.3.0 - Production on Sat Jun 11 07:29:50 2005

Copyright (c) 1982, 2004, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> DROP USER user1 CASCADE;

User dropped.

SQL> CREATE TABLESPACE user1 
  2  DATAFILE '/Volumes/u02/oradata/test1/user1.dbf'
  3  SIZE 100M
  4  AUTOEXTEND ON NEXT 10M
  5  MAXSIZE 2000M;

Tablespace created.

SQL> CREATE USER user1                    
  2  IDENTIFIED BY user1
  3  DEFAULT TABLESPACE user1
  4  TEMPORARY TABLESPACE temp;

User created.

SQL> GRANT CONNECT, RESOURCE TO user1;

Grant succeeded.

SQL> ALTER USER user1 QUOTA UNLIMITED ON user1;

User altered.

Technorati Tags:

No comments: