how to logon Oracle DB
来源:互联网 发布:比价神器 软件下载 编辑:程序博客网 时间:2024/05/20 01:10
1.ps -ef|grep pmon
2.su - oracle
3.export ORACLE_SID=TWJDE
4.sqlplus "/ as sysdba" 后面不加;,加了不work
select owner,object_name,status from dba_objects where object_name like '%F91320'
3. desc SY810.F91300
4.col JSSCHROLE for a5
set long 999
set lines 140
set pages 9999
5.select * from sy810.F91320 where rownum < 5;
SELECT SUM(BYTES) FROM DBA_SEGMENTS WHERE OWNER='SY810' AND SEGMENT_NAME IN ('F91300','F91320');
!df -g
select * from nls_database_parameters;
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
exp \'/ as sysdba\' du
exp help=y
check the table size:
SQL> desc dba_segments
SQL> select sum(bytes/1024/1024)MB from dba_segments where segment_name='F91320';
to be continue .....
- how to logon Oracle DB
- How to logon windows automatically
- How to Remote Access Oracle DB
- ORACLE 11G HOW TO FIX ORA-01017: invalid username /password;logon denied
- How to start/stop DB instance of Oracle under Linux
- Liferay 7 CE: How to add support for Oracle DB
- How To Install Berkeley DB
- How to read settings.db
- how to ssh logon remote host without password
- How to use .profile when logon by CDE under AIX
- How to stop&start Oracle EBS Server(DB Server&Apps Server)
- How to connect DB in Java
- How to update or delete db
- How to use Berkeley DB Java Edition
- How To Decrypt WeChat EnMicroMsg.db Database?
- How to unlock user in DB
- How to handle Mongoose DB connection interruptions
- nice to logon
- dom4j 把 文本 转成 XML
- Android:BaseAdapter优化之ViewHolder 显示系统已经安装应用并打开
- 秒杀多线程第二篇 多线程第一次亲密接触 CreateThread与_beginthreadex本质区别
- Appium(JAVA)Windows 7系统搭建及示例运行
- CocosStudio UI编辑器(1.6.0)使用调研 (基于cocos2dx-3.2)
- how to logon Oracle DB
- FirstWindow
- 细谈select函数(C语言)
- (12) 初学cocos2dx lua
- Java 中枚举类型的使用
- hdu 4778 Gems Fight!
- POJ 1036 Gangsters 题解
- QTP 自定义方法将IE最大化最小化
- ArcObjects帮助文档翻译--释放COM对象 Releasing COM references