Skip to content
Channel [K]

tips

  1. Home>
  2. tips

How to resolve ORA-14117: partition resides in offlined tablespace

  • Post author:Kamus
  • Post published:May 27, 2009
  • Post category:Oracle Database
  • Post comments:6 Comments

SQL> drop tablespace SUMM_DATA07; drop tablespace SUMM_DATA07 * ERROR at line 1: ORA-14404: partitioned table contains partitions in a different tablespace appears. SQL> alter table CCDAWORK.S_ACCT_FIX drop partition P6; alter…

Continue ReadingHow to resolve ORA-14117: partition resides in offlined tablespace
Copyright - WordPress Theme by OceanWP