The dropping of the EUL$ depends on whether or not you are using them. The EUL, or End User Layer, tables are used by Discoverer to hold the definitions that are used in the reporting process that insulate the user from the complexities of the database.
So the simple answer is probably that you should not drop these tables. However, if you are not using Discoverer or OFSA then you may be all right. As always be sure before you do any cutting, also back them up before you drop them...just in case.
As for your second question about the date that a table was created? That's an easy one... use the following query and look at the created column:
select object_name,created,last_ddl_time from all_objects where object_Type='TABLE'
Hope this all helps.
For More Information
- Dozens more answers to tough data warehousing questions from Ian Abramson are available here.
- The Best Data Warehousing and Business Intelligence Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our PL/SQL, database administration and data warehousing gurus are waiting to answer your toughest questions.
Dig Deeper on Data warehouse software
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.