linux与oracle，乱写的，备忘

after login:

$su - oracle

enter listener console:

$lsnrctl

check listener status:

LSNRCTL>status

launch listener:

LSNRCTL>start

exit listener console.

enter oracle sql console:

$sqlplus /nolog

connect as a system dba:

SQL>conn / as sysdba

launch databases:

SQL>startup

create a user:

SQL>create user snail identified by wong

grant privileges:

SQL>grant connect,resource to snail

grant privileges:

SQL>grant select any table,update any table, delete any table,create any table to snail;

create tablespace:

CREATE TABLESPACE "SNAIL" 
    LOGGING 
    DATAFILE '/opt/app/oracle/oradata/SNAIL/SNAIL.dbf' SIZE 50M 
    EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO 

create temporary dataspace:

CREATE TEMPORARY TABLESPACE "SNAIL_TEMP" DATAFILE '/opt/app/oracle/oradata/SNAIL/SNAIL_TEMP.dbf' SIZE 10M

grant tablespace to user:

ALTER USER "SNAIL"  DEFAULT TABLESPACE "SNAIL" 
    TEMPORARY TABLESPACE "SNAIL_TEMP"