epifanio67
asked on
Oracle 11g: sqlplus: command to display list of tables?
Hello Experts,
via sqlplus is there a way to display all tables?
also, is there a way to find out when was the last time the db updated?
Regards,
via sqlplus is there a way to display all tables?
also, is there a way to find out when was the last time the db updated?
Regards,
There is a last_ddl_time in all_objects (same for the DBA nad USER views) that will show the last time the object was modofied if that helps?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>you can use ORA_ROWSCN
This is not a 100% guarantee. It should be a good estimate though.
http://docs.oracle.com/cd/E11882_01/server.112/e26088/pseudocolumns007.htm#SQLRF50953
This pseudocolumn is useful for determining approximately when a row was last updated. It is not absolutely precise, because Oracle tracks SCNs by transaction committed for the block in which the row resides. You can obtain a more fine-grained approximation of the SCN by creating your tables with row-level dependency tracking. Refer to CREATE TABLE ... NOROWDEPENDENCIES | ROWDEPENDENCIES for more information on row-level dependency tracking.
This is not a 100% guarantee. It should be a good estimate though.
http://docs.oracle.com/cd/E11882_01/server.112/e26088/pseudocolumns007.htm#SQLRF50953
This pseudocolumn is useful for determining approximately when a row was last updated. It is not absolutely precise, because Oracle tracks SCNs by transaction committed for the block in which the row resides. You can obtain a more fine-grained approximation of the SCN by creating your tables with row-level dependency tracking. Refer to CREATE TABLE ... NOROWDEPENDENCIES | ROWDEPENDENCIES for more information on row-level dependency tracking.
ASKER
Thank you experts,
the problem I am having is that I don't know the tables names... or have access to ERD... so, I can't run a simple query:
select table_name from all_tables
see what I mean?
I wanted to see if I could display all tables via command line...
Thanks experts...
the problem I am having is that I don't know the tables names... or have access to ERD... so, I can't run a simple query:
select table_name from all_tables
see what I mean?
I wanted to see if I could display all tables via command line...
Thanks experts...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you experts...<br />I really appreciate your help
or the dba_tables view if you have permission (user_tables for the ones the user owns).
>>the last time the db updated?
I don't think this is available unless you are auditing the tables.