cancel
Showing results for 
Search instead for 
Did you mean: 

dba_tablespaces column plugged_in missing

Former Member
0 Kudos
121

Hi,

I am getting an error ORA-904 while executing dbacockpit. I seems, that something is wrong with my dba_tablespaces.

The error is, that column plugged_in is missing.

The error occured after starting the preparations for an upgrade from SAP ERP 6.0 EHP6 to SAP ERP 6.0 EHP7.

I am on Oracle 12c.

Could someone tell me why this column could vanish and how do I get it back?

Best regards

Christian

Accepted Solutions (1)

Accepted Solutions (1)

JamesZ
Advisor
Advisor
0 Kudos

Hi Christian,

plugged_in is still valid in 12c. Did you check "desc dba_tablespaces"? Can you find "plugged_in" column listed?


Best regards,

James


Former Member
0 Kudos

Hi James,

the column was not visible in a desc dba_tablespaces as user sapsr3, but as user sys.

Dba_tablespaces was missing in dba_sysonyms, too.

I got a downtime and started catproc.sql and catalog.sql, now it seems to be ok.

Best regards

Christian

Answers (1)

Answers (1)

fidel_vales
Employee
Employee
0 Kudos

Hello,

curious, curious.

As indicated by James, the column PLUGGED_IN should exist in Oracle 12c.

please, get output of the following queries (format it as monospace or put a screenshot so it is readable)

select comp_id, version, status from dba_registry;

select owner, object_name, object_type, timestamp from dba_objects where object_name = 'DBA_TABLESPACES';

select owner, table_owner, table_name from dba_synonyms where synonym_name = 'DBA_TABLESPACES';