1. 添加用户 create user user_name identified by password; 2. 用户从sqlplus登录,需要create session 权限。所以需要执行如下语句。 grant create session to user_name; 3. 赋予用户查看某个表的权限,可以使用: grant select on table_name to user_name; 4. 撤销某个授权: revoke select on table_name from user_name; revoke create table from user_name; revoke create session from user_na...
man man command Manual Pages - Help with any UNIX command man ps Help on the UNIX ps command clear clear To clear the screen pwd pwd Present / Current Working Directory cd cd [directoryname] Change directory, without argument will change your working directory to your home directory. cd work Change working directory to "work" cd .. Change working dir...
Lunatic 整理 1. 删除表的注意事项 在删除一个表中的全部数据时,须使用TRUNCATE TABLE 表名;因为用DROP TABLE,DELETE * FROM 表名时,TABLESPACE表空间该表的占用空间并未释放,反复几次DROP,DELETE操作后,该TABLESPACE上百兆的空间就被耗光了。 2.having 子句的用法 having 子句对 group by 子句所确定的行组进行控制,having 子句条件中只允许涉及常量,聚组函数或group by 子句中的列. 3.外部联接"+"的用法 外部...
oracle里常用命令...... 第一章:日志管理 1.forcing log switches sql>; alter system switch logfile; 2.forcing checkpoints sql>; alter system checkpoint; 3.adding online redo log groups sql>; alter database add logfile [group 4] sql>; ('/disk3/log4a.rdo','/disk4/log4b.rdo') size 1m; 4.adding online redo log members sql>; alter database add logfile member sql>; '/disk3...
第一章:日志管理 1.forcing log switches sql> alter system switch logfile; 2.forcing checkpoints sql> alter system checkpoint; 3.adding online redo log groups sql> alter database add logfile [group 4] sql> ('/disk3/log4a.rdo','/disk4/log4b.rdo') size 1m; 4.adding online redo log members sql> alter database add logfile member sql> '/disk3/log1b.rdo' to group 1, sql> '/disk4/log2b.rdo' to...
1: pwd pwd Present / Current Working Directory (显示当前目录) 2:cd cd [directoryname] Change directory (改变当前目录) without argument will change your working directory to your home directory. (没有参数则到home目录) 3: ls ls [-options] [names] List files. [names] if omitted, will list all files and subdirectories in the directory. Wild cards can be specified. (显示文件及当前目录下的子目录)...
oracle里的常用命令 第一章:日志管理 1.forcing log switches sql>; alter system switch logfile; 2.forcing checkpoints sql>; alter system checkpoint; 3.adding online redo log groups sql>; alter database add logfile [group 4] sql>; ('/disk3/log4a.rdo','/disk4/log4b.rdo') size 1m; 4.adding online redo log members sql>; alter database add logfile member sql>; '/disk3/log1b.rdo' to group 1,...
第一章:日志管理 1.forcing log switches sql>; alter system switch logfile; 2.forcing checkpoints sql>; alter system checkpoint; 3.adding online redo log groups sql>; alter database add logfile [group 4] sql>; ('/disk3/log4a.rdo','/disk4/log4b.rdo') size 1m; 4.adding online redo log members sql>; alter database add logfile member sql>; '/disk3/log1b.rdo' to group 1, sql...