drop tablespace ORA-01561案例
今天遇到了一个奇怪的问题，有一个表空间无法删除，开始删除提示表空间内有对象，加上INCLUDING CONTENTS选项级连删除又报
ORA-01561: failed to remove all objects in the tablespace specified，查一些系统视图该对象还不存在
ORA-01461: can bind a LONG value only for insert into a LONG column解决
ERROR at line 1:
ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-06512: at line 4
ORA-01652: unable to extend temp segment by 8192 in tablespace
今天发现了这个问题，分析记录一下问题是这样子的，有一个表记录7亿，要在表上建索引，临时表空间已分配32G，DB DEFAULT BLOCK SIZE 8K，建索引时报了这个错误
ORA-00443: background process “PMON” did not start分析
Connected to an idle instance.
SQL> startup
ORA-00443: background process “PMON” did not start
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at “WMSYS.WM_CONCAT_IMPL”, line 30
loss of all controlfile,database is automatic shutdown abort?(丢失所有控制文件，数据库会关闭？)
Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you…
expdp with sys or Include Multiple tables like
UDE-00008: operation generated ORACLE error 28009
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
sqlplus 限制用户delete(product_user_profile) sp2-0544
SQL> delete test where id=1;
SP2-0544: Command “delete” disabled in Product User Profile
sqlplus login Error accessing PRODUCT_USER_PROFILE
SQL> conn zwz/zwz;
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
IMP-00046: using FILESIZE value from export
if export specify the FILESIZE parameter,so when you import specify TABLES parameter and you must specify the FILESIZE same ths export filesize too
oracle僵死Process m000 died,J000 died
今天无意执行了一个脚本，后来发现kill 了j000和m000的进程，oracle被僵死在那里，j000是job的守护进程，m000是MMON进程启动的从属平行进程，都是轻量级但不容忽视！
ORA-32004: obsolete and/or deprecated parameter(s) specified
SQL> startup mount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
ORA-00201: control file version 10.2.0.3.0 incompatible with ORACLE version…
alter database mount
*
ERROR at line 1:
ORA-00201: control file version 10.2.0.3.0 incompatible with ORACLE version 10.2.0.1.0
ORA-04068: existing state of packages has been discarded
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped stored procedure “ANBOB.P_INSERT”
EXP-00008: 遇到 ORACLE 错误 904
EXP-00008: 遇到 ORACLE 错误 904
ORA-00904: “MAXSIZE”: invalid identifier
ORA-28056 Writing audit records to Windows Event Log failed
今天 有人提起了这个异常，未能将审计记录写入Windows 事件日志，这是WINDOWS平台的一个通病，如果开启了审计，如果应用软件再有频繁操作，一会儿功夫可能就会写满日志最大容量。
SP2-0749: Cannot resolve circular path of synonym “DBA_ROLLBACK_SEGS”
sys@ORCL> DESC DBA_ROLLBACK_SEGS;
SP2-0749: Cannot resolve circular path of synonym “DBA_ROLLBACK_SEGS”
ORA-04089: cannot create triggers on objects owned by SYS
今天做实验，忘记切换用户,在sys下建立触发器时发现了ORA-04089，不能建立trigger在sys的对象上
SQL> conn / as sysdba
Connected.
