|
|
|
|
| Re: History tables [message #199545 is a reply to message #199531] |
Wed, 25 October 2006 01:33   |
 |
Littlefoot
Messages: 21808
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: 10707
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
