oracle 有用命令
来源:互联网 发布:雀圣软件官方 编辑:程序博客网 时间:2024/06/09 23:21
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;
- oracle 有用命令
- oracle 有用的SQL语句与oracle的 基本命令
- 一些有用的命令
- 有用的网络命令
- sql server 有用命令
- 有用的linxu命令
- 有用的linux命令
- emacs有用的命令
- 有用的Bash命令
- 有用的dos命令
- 一些有用的命令
- 一些有用的命令
- 有用的Dos命令
- 有用的linux 命令
- 有用的OPENSSL命令
- 有用的批处理命令
- 有用的命令
- vi有用的命令
- 抽屉原理总结
- android ndk初步1
- 如何展示主数据的历史变化(三)
- Java反射机制
- 如何展示主数据的历史变化(四)
- oracle 有用命令
- OpenGL模型视图变换、投影变换、视口变换
- enyo学习笔记1
- 动态扩大数组
- 【巴蜀模拟试题】:L语言(difficult)
- android 类似QQ 换皮肤 实现思路 apk资源共享
- HDU-1533 Going Home
- va_start va_end 的使用和原理
- 程序员的十层楼:大家都来测测你的技术层级