ChinaUnix.net
相关文章推荐:

inurlblogchinaunixnet 31个Oracle常用问题及命令

oracle 命令中 想实现连接的同时也起别名: 如下 select name NA||id DD from dept; 运行不了!! 高手帮忙看看 非常感谢!!

by bzray - Oracle - 2008-11-04 19:24:37 阅读(2227) 回复(11)

相关讨论

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...

by mingjwan - Solaris文档中心 - 2006-01-09 20:11:06 阅读(461) 回复(0)

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...

by swwin - Oracle - 2003-07-27 16:45:08 阅读(973) 回复(0)

Lunatic 整理 1. 删除表的注意事项 在删除一表中的全部数据时,须使用TRUNCATE TABLE 表名;因为用DROP TABLE,DELETE * FROM 表名时,TABLESPACE表空间该表的占用空间并未释放,反复几次DROP,DELETE操作后,该TABLESPACE上百兆的空间就被耗光了。 2.having 子句的用法   having 子句对 group by 子句所确定的行组进行控制,having 子句条件中只允许涉及常量,聚组函数或group by 子句中的列. 3.外部联接"+"的用法   外部...

by Lunatic - Oracle - 2003-11-13 16:12:13 阅读(1511) 回复(7)

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...

by copyking - 存储文档中心 - 2008-07-16 09:35:59 阅读(735) 回复(0)

第一章:日志管理 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...

by jankie - BSD文档中心 - 2006-07-28 08:37:13 阅读(566) 回复(0)

oracle 常用命令见附件

by stone_jinhao - Oracle - 2013-09-17 15:29:43 阅读(83760) 回复(253)

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. (显示文件及当前目录下的子目录)...

by jeffreyli - Oracle - 2004-09-23 20:53:18 阅读(1509) 回复(5)

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,...

by jeffreyli - Oracle - 2004-09-23 00:25:35 阅读(885) 回复(7)

第一章:日志管理 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...

by victor08 - Oracle - 2010-04-03 08:52:43 阅读(33309) 回复(85)

我是菜鸟,想问问怎么备份oracle?orcale常用命令手册哪里有的下?

by cczb1987 - Oracle - 2008-10-10 09:24:47 阅读(1531) 回复(0)