|
|
| Re: History tables [message #199531 is a reply to message #199518] |
Wed, 25 October 2006 00:55   |
nirav_hyd
Messages: 662
Registered: December 2005
Location: Hyderabad
|
Senior Member |
|
|
|
AFAIK, there is nothing ilke that! I mean in standard oracle 9i database..are you talking about Oracle Apps?
|
|
|
|
| Re: History tables [message #199545 is a reply to message #199531] |
Wed, 25 October 2006 01:33 |
 |
Littlefoot
Messages: 16927
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
History tables are tables that contain "old" data. For example (don't take it literally), there's a production table which holds this year's data. Besides it, there's a history table which contains data from previous years and is populated on Jan 1st as
INSERT INTO history_table SELECT * FROM production_table;
Here is a link to the page which discusses history tables - check Tables that describe history section. There are a few ways to accomplish this task; read it and see whether it is what you are looking for.
[Updated on: Wed, 25 October 2006 01:34] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: History tables [message #199631 is a reply to message #199555] |
Wed, 25 October 2006 09:49 |
 |
Mahesh Rajendran
Messages: 10572
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Just to show how vague your question could be,
try this yourself. Login as sys and
sql>select table_name from cat where table_name like ('%HISTORY%');
The output you get depends on the options you use and your oracle version. In oracle 10gR2 without any options i got around 49 "history" tables.
Now choose your spefic history table/view and search oracle doc (refernce/sql guide) for details of the table.
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
