Oracle when was table created

Original date created for an Oracle table Oracle Database Tips by Donald BurlesonNovember 20, Question: I need to understand how the data dictionary stores the created date for an Oracle table. Is there a way to keep the original date created after a table reorganization? The only way to store an original created date, is to create a data dictionary extension table and keep track of it manually. If no column names are specified for the new table, then all the columns in the result of the query expression are used to create same-named columns in the new table, of the corresponding data type s.

If one or more column names are specified for the new table, then the same number of columns must be present in the result of the query expression; the data types of those columns are used for the corresponding columns of the new table. The WITH NO DATA clause specifies that the data rows which result from evaluating the query expression are not used; only the names and data types of the columns in the query result are used.

Collectives on Stack Overflow. Learn more. How to find out when a particular table was created in Oracle? Ask Question. Asked 10 years, 11 months ago. Active 4 years, 9 months ago. Viewed k times. In Oracle, is there a way to find out when a particular table was created? Improve this question. Moeb Moeb 9, 27 27 gold badges 81 81 silver badges bronze badges.

But this time, the customer ID should be the primary key for the table. Based on the departments table below, create an Oracle table called employees that stores employee number, employee name, department, and salary information. The primary key for the employees table should be the employee number.