![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle DBA
文章平均质量分 79
amcaesar
it's me
展开
-
Oracle Commands
打开服务器net start oracleservicebinbo打开监听器lsnrctl start关闭服务器net stop oracleservicebinbo关闭监听器lsnrctl stop===============================================================清屏clear screen*原创 2011-10-26 22:45:08 · 404 阅读 · 0 评论 -
Oracle 故障处理合辑
ORA-00001~ORA-00100·ORA-00001 normal,successful completion·ORA-00018 maximum number of sessions exceeded·ORA-00054 resource busy and acquire with NOWAIT specifie·ORA-00转载 2011-10-26 21:42:19 · 4327 阅读 · 0 评论 -
schema and user
A schema is required for some tuning categories. Because Oracle Expert is not a schema editor, it does not keep 100% of a user’s schema, nor does it provide editing capabilities for all possible sch翻译 2011-12-08 21:18:06 · 440 阅读 · 1 评论 -
OCP培训笔记-flashback
FlashBackKeywords: SQL> conn scott/tigerConnected.SQL> select * from tab;TNAME TABTYPE CLUSTERID------------------------------ ------- ----------BIN$u4X8FW5uuvf原创 2012-03-19 21:26:44 · 544 阅读 · 0 评论 -
OCP培训笔记-DataPump
Mar18: DataPumpKEY WORDS:DATA PUMP ; EXPORT expdp ,4 modules by user/tablespace/tables/full;IMPORT impdp , 4 modules either;DIRECTORY create direacory ,grant ** on directory*****************原创 2012-03-19 21:29:37 · 24752 阅读 · 0 评论 -
OCP培训笔记-External
SQL> desc scott.dept Name Null? Type ----------------------------------------- -------- ---------------------------- DEPTNO原创 2012-03-19 21:30:45 · 609 阅读 · 0 评论 -
格式化,分区,挂载磁盘
磁盘分区,格式化,挂载磁盘fdisk -l >>>查看当前分区信息fdisk /dev/sde >>>将新盘分区mkfs -t ext3 /dev/sde1>>>格式化磁盘mkdir /caesar >>>系统中新建一个文件夹,由于挂载chomd 777 /caesar >>>给新文件夹授权mount /dev/sde1 /caesar >>>挂载磁盘到新建原创 2012-04-06 20:12:21 · 399 阅读 · 0 评论