[Oracle] ORACLE ERROR

ORACLE 錯誤筆記

ORA-01653
ORA-12514

ORA-01653: unable to extend table 

 經過同仁提點使用
Alter table TABLE_NAME enable row movement;
Alter table TABLE_NAME SHRINK SPACE COMPACT;
Alter table TABLE_NAME SHRINK SPACE;
Alter table TABLE_NAME disable row movement;
參考資料大家自己進去看囉!!!

參考資料 : https://rock08.pixnet.net/blog/post/35571664-oracle-%E7%B8%AE%E5%B0%8F%E5%8D%80%E6%AE%B5%28shrink-space%29


ORA-12514: Message 12514 not found with two Oracle clients

There are few possibilities for the error:

  1. Most likely the tnsnames.ora contains an error after all. Copy it from some other client where the connection works
  2. The reason may also be that there is some setting in sqlnet.ora that 'guides' the client to behave faulty. Copy that also from a working client (or remove it totally if it is not used elsewhere)
  3. The reason may also be that tnsnames.ora are tried to read from other version's directories. Make sure you have identical tnanames.ora and sqlnet.ora in both versions' ...\network\admin -dir.
  4. A rare change is also that you have TNS_ADMIN set in your registry and it points to somewhere else than than the default ...\network\admin.

參考資料 : https://serverfault.com/questions/350921/ora-12514-message-12514-not-found-with-two-oracle-clients

My Solution

重新檢視TNSNAME.ORA ,確認裡面字串是否正確