oracle 有用命令

sqlplus uname/psw@tns:port/service name.

------------------------------------------------------------------------------------------

ALTER ROLLBACK SEGMENT SYSTEM OFFLINE;
DROP ROLLBACK SEGMENT SYSTEM;


CREATE ROLLBACK SEGMENT SYSTEM
  TABLESPACE SYSTEM
  STORAGE    (
              INITIAL          112K
              MINEXTENTS       1
              MAXEXTENTS       32765
             );
ALTER ROLLBACK SEGMENT SYSTEM ONLINE;

------------------------------------------------------------------------------------------

DROP ROLE RESOURCE;


CREATE ROLE RESOURCE NOT IDENTIFIED;


GRANT CREATE TYPE TO RESOURCE;
GRANT CREATE TABLE TO RESOURCE;
GRANT CREATE CLUSTER TO RESOURCE;
GRANT CREATE TRIGGER TO RESOURCE;
GRANT CREATE OPERATOR TO RESOURCE;
GRANT CREATE SEQUENCE TO RESOURCE;
GRANT CREATE INDEXTYPE TO RESOURCE;
GRANT CREATE PROCEDURE TO RESOURCE;

------------------------------------------------------------------------------------------

DROP TABLESPACE UNDOTBS1 INCLUDING CONTENTS AND DATAFILES;


CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE 
  'C:\APP\ADMINISTRATOR\ORADATA\ORCL\UNDOTBS01.DBF' SIZE 240M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED
ONLINE
RETENTION NOGUARANTEE
BLOCKSIZE 8K
FLASHBACK ON;

·········································································································

DROP PROFILE "DEFAULT" CASCADE;


CREATE PROFILE "DEFAULT" LIMIT
  SESSIONS_PER_USER UNLIMITED
  CPU_PER_SESSION UNLIMITED
  CPU_PER_CALL UNLIMITED
  CONNECT_TIME UNLIMITED
  IDLE_TIME UNLIMITED
  LOGICAL_READS_PER_SESSION UNLIMITED
  LOGICAL_READS_PER_CALL UNLIMITED
  COMPOSITE_LIMIT UNLIMITED
  PRIVATE_SGA UNLIMITED
  FAILED_LOGIN_ATTEMPTS 10
  PASSWORD_LIFE_TIME 180
  PASSWORD_REUSE_TIME UNLIMITED
  PASSWORD_REUSE_MAX UNLIMITED
  PASSWORD_LOCK_TIME 1
  PASSWORD_GRACE_TIME 7
  PASSWORD_VERIFY_FUNCTION NULL;