博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
oracle操作
阅读量:7222 次
发布时间:2019-06-29

本文共 2772 字,大约阅读时间需要 9 分钟。

--查看并行度select table_name,degree from user_tables;  --设置并行ALTER TABLE   rsk_book_histogram   PARALLEL 2;--取消并行ALTER TABLE   rsk_book_histogram   NOPARALLEL;--删除表空间 DROP TABLESPACE TBNAME INCLUDING CONTENTS AND DATAFILES; 有时可能删除不了需要重新利用原有的数据文件 create tablespace ALM datafile 'D:\DataBase\Oracle\ALM\ALM\ALM.dbf' ;

  DROP TABLESPACE ALM INCLUDING CONTENTS AND DATAFILES;

先利用原来的数据文件创建表空间,再删除骗过oracle--闪回SELECT *FROM etl_column AS OF TIMESTAMP  to_timestamp('2017-11-10 14:05:00', 'yyyy-mm-dd hh24:mi:ss')--查询死锁select sess.sid,     sess.serial#,     lo.oracle_username,     lo.os_user_name,     ao.object_name,     lo.locked_mode     from v$locked_object lo,     dba_objects ao,     v$session sess where ao.object_id = lo.object_id and lo.session_id = sess.sid; select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID; select * from tran_bond_detail;--杀掉死锁alter system kill session 'sid,serial';  1.建立表空间,create tablespace "NETHRA" DATAFILE 'D:\DataBase\Oracle\iClass\iclass\iclass.DBF' SIZE 100MAUTOEXTEND   ON   NEXT  10M2.创建用户并授权CREATE USER "NETHRA" PROFILE "DEFAULT" IDENTIFIED BY "nethra" DEFAULT TABLESPACE "NETHRA" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCKGRANT "CONNECT" TO "NETHRA"GRANT "DBA" TO "NETHRA3.exp nethra/nethra@iclass file=d:\iclass20160108.dmp full=y4.imp nethra/nethra@iclass file=d:\iclass20160108.dmp full=y--1G=1024MB --1M=1024KB --1K=1024Bytes --1M=11048576Bytes --1G=1024*11048576Bytes=11313741824Bytes SELECT a.tablespace_name "表空间名", total "表空间大小", free "表空间剩余大小", (total - free) "表空间使用大小", total / (1024 * 1024 * 1024) "表空间大小(G)", free / (1024 * 1024 * 1024) "表空间剩余大小(G)", (total - free) / (1024 * 1024 * 1024) "表空间使用大小(G)", round((total - free) / total, 4) * 100 "使用率 %" FROM (SELECT tablespace_name, SUM(bytes) free FROM dba_free_space GROUP BY tablespace_name) a, (SELECT tablespace_name, SUM(bytes) total FROM dba_data_files GROUP BY tablespace_name) b WHERE a.tablespace_name = b.tablespace_name 5.alter tablespace HRA_GFadd datafile  'D:\DATABASE\ORACLE\HRA_DEV\GF_STG_TBS21.dbf' size 1024M autoextend on ;6.查看主键索引select a.constraint_name c,  a.column_name                                             from user_cons_columns a, user_constraints b                                             where a.constraint_name = b.constraint_name                                             and b.constraint_type = 'P'                                             AND B.owner = '{Holworth.Utility.HraUtility.GetDataBaseInfo(AppEnum.Web).user}'                                             and a.table_name = '{targetTable}'7.添加主键约束alter table {targetTable} add constraint pk_{targetTable.Substring(0, len)} primary key({IdField}) 8.删除主键约束alter table {targetTable} drop constraint {cname}

 

转载于:https://www.cnblogs.com/kexb/p/10086364.html

你可能感兴趣的文章
IntelliJ IDEA 乱码解决方案 (项目代码、控制台等)
查看>>
PHP项目记录
查看>>
.net面试题系列文章七(附答案)
查看>>
FastSocket
查看>>
ionic $ionicSlideBoxDelegate 滑动框事件
查看>>
点击文字,把input type="radio"也选中
查看>>
第一章 Java多线程技能
查看>>
Java 集合系列-第八篇-Map架构
查看>>
springmvc 3.2 @MatrixVariable bug 2
查看>>
React-Native PanResponder手势识别器
查看>>
IOS11 光标错位问题
查看>>
如何设计用户登录
查看>>
linux安装mysql5.7.19
查看>>
Zookeeper+ActiveMQ 集群实现
查看>>
加权有向图问题2----多源最短路径问题(Floyd算法)和关键路径算法
查看>>
logback logback.xml常用配置详解(三) <filter>
查看>>
KgMall B2B/B2B2c/C2C版店铺商号初始化
查看>>
Linux内核的ioctl函数学习
查看>>
Liunx Shell入门
查看>>
Thread的中断
查看>>