oracle
DBA柠檬
不积跬步,无以至千里.不积小流,无以成江海
展开
-
oracle19c修改sys密码报错OPW-00029
19c 修改sys密码使用orapwd命令,报错OPW-00029orapwd file=’+DATA’ dbuniquename=orcl sys=y password=‘passwd’ force=yOPW-00029:Password complexity failed for SYS user:Password mouyst contain at least 8 characters:修改密码长度大于8 报错OPW-00029:Password complexity failed f原创 2021-05-06 13:04:53 · 2699 阅读 · 0 评论 -
通过impdp导出索引脚本
impdp tests/tests directory=dump_dir logfile=logfile.log network_link=crm_test REMAP_TABLESPACE=CRMREPORT:USERS SQLFILE=sqlfile.sql include=INDEX来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10130206/viewspace-1040764/,如需转载,请注明出处,否则将追究法律责任。...转载 2021-02-03 14:13:48 · 250 阅读 · 0 评论 -
数据泵迁移之数据落地迁移
查看表非空约束SET SERVEROUT ON BEGIN FOR I IN (select OWNER,CONSTRAINT_NAME,CONSTRAINT_TYPE,TABLE_NAME,SEARCH_CONDITION from dba_constraints where TABLE_NAME='&table_name' and owner='&username' and CONSTRAINT_TYPE='C') LOOP IF INSTR(I.SEARCH_CONDITION原创 2021-01-28 17:49:38 · 159 阅读 · 1 评论 -
ORACLE数据库约束-非空约束查询
非空约束IS NOT NULL1、查询指定用户、表的非空约束SET SERVEROUT ON BEGIN FOR I IN (select OWNER,CONSTRAINT_NAME,CONSTRAINT_TYPE,TABLE_NAME,SEARCH_CONDITION from dba_constraints where TABLE_NAME='&table_name' and owner='&username' and CONSTRAINT_TYPE='C') LOOP IF原创 2021-01-28 11:56:33 · 1433 阅读 · 0 评论 -
oracle数据库修改归档模式
修改归档模式标签(空格分隔): oracle##查看归档模式su - oraclesqlplus / as as sysdbaarchive log list;##查看日志产生频率select a.recid,to_char(a.first_time,'yyyy-mm-dd hh24:mi:ss') begin_time,b.recid,to_char(b.first_time,'yyyy-mm-dd hh24:mi:ss') end_time,round((b.first_time原创 2021-01-15 16:31:43 · 425 阅读 · 0 评论 -
Oracle常用DDL、DML SQL语句
Oracle常用DDL、DML SQL语句一、DMLDML(data manipulation language)数据操纵语言:主要有:SELECTINSERTUPDATEDELETEMERGECALLEXPLAIN PLANLOCK TABLE数据库运维最经常用到的 SELECT、EXPLAIN PLAN;常用DML语句select:1、查询数据库实例名和实例状态select instance_name,status from gvinstance;2、查询数据库名和数据库原创 2021-01-15 16:09:15 · 2815 阅读 · 0 评论