Home » RDBMS Server » Server Administration » dba_tables.container_data (DB 12.1.x)
dba_tables.container_data [message #621701] Sat, 16 August 2014 10:45 Go to previous message
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
Senior Member
This column is the last column in the %_TABLES views. In the CDB I happen to be working on, it is always set to NO:
cdba>
cdba> alter session set container=cdb$root;

Session altered.

cdba> select container_Data,count(*) from cdb_tables group by container_data;

CON   COUNT(*)
--- ----------
NO        9271

cdba>
The docs says this,Quote:
Indicates whether the table contains container-specific data. Possible values:
YES if the table was created with the CONTAINER_DATA clause
NO otherwise
but I can find no explanation of this clause. Any ideas? Perhaps a way of creating shared tables? I've had a look through ?/rdbms/admin, but I can't find any example of it being used.

Thank you for any insight.
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Help about Log file Oracle
Next Topic: what is the procedure to select mysql database data from oracle 11g
Goto Forum:
  


Current Time: Thu Apr 25 07:43:32 CDT 2024