How I can Find Undelying Tables & Views in Oracle 11i (HRMS)

pts.
Tags:
E-business
Hi,,, i want to ask about the way that help me in finding the underlying Tables & Viwes because i used Record History Feature but it didn't work (Record History is not available). Thanks in advance for your corporation..

Answer Wiki

Thanks. We'll let you know when a new response is added.

In each version of Oracle, there’s a management tool. I won’t mention the name of it here, because the name keeps changing. However, it should be on your menues or in your applications list. You can navigate from database to schema, and within the schema see your tables, views, and program objects. Within tables, you can see columns, triggers, constraints, indeces, and the like. Within program objects, you can see procedures, functions, and packages.

To determine which tables are used in views, you can go to views and display the view definition. To determine which tables and views are used in program objects, you can go to the particular program object, and display its definition.

Sheldon Linker (sol@linker.com)
Linker Systems, Inc. (www.linker.com)
800-315-1174 (+1-949-552-1904)

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following