on 02-27-2013 9:07 PM
Hi Experts,
I'm looking in my Q system to see some dates where my tables in my specific schema were created.
I'm thinking there should be some table that shows that kinda of data.
If I exe this sql:
SELECT *
FROM "SYS"."M_TABLES"
WHERE SCHEMA_NAME = 'my_schema'
I can see the number of rows in the table but it does not have the date the table was created or activated.
Maybe it is in a table that stored data related to imports as it was imported.
Mike
Hi Mike,
Have you had a look at view SYS.M_CS_TABLES? There is a CREATE_TIME column in this view that will have created timestamp.
Thanks,
Anooj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.