Home > database >  ORALCE how to distinguish the system's own table and created after the user table
ORALCE how to distinguish the system's own table and created after the user table

Time:09-22

New contact did not specify a project
Some table creation to SYS name inside, I was totally confused, now put these tables a leakproof I totally can't distinguish which is the export

CodePudding user response:

Select * from dba_objects o where o.o bject_type='TABLE';
Watch the creation time of field probably should be able to distinguish

CodePudding user response:

You look under your table name, and then owner dba_table field='SYS' and table_name=your table name

CodePudding user response:

 
The select table_name
The from dba_objects, v $database
Where o.o bject_type='TABLE'
And object creation time field & gt; Database creation time, the place of key (this specific field name can't remember, anyway, thinking is the)

CodePudding user response:

The best solution, is to look for a test server or VM, install a version of the same library, including patches and components also should agree,
It is ok to see which tables are more,

CodePudding user response:

You can build a dblink, to a and you the same version of the database, and then write a cycle than in it
  • Related