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 nameCodePudding 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