Home » SQL & PL/SQL » SQL & PL/SQL » History tables
History tables [message #199518] Wed, 25 October 2006 00:05 Go to next message
raviraviki
Messages: 135
Registered: May 2005
Senior Member
What are history tables in oracle?

Re: History tables [message #199531 is a reply to message #199518] Wed, 25 October 2006 00:55 Go to previous messageGo to next message
nirav_hyd
Messages: 711
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 Go to previous messageGo to next message
Littlefoot
Messages: 18833
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 #199548 is a reply to message #199518] Wed, 25 October 2006 01:39 Go to previous messageGo to next message
raviraviki
Messages: 135
Registered: May 2005
Senior Member
No,not this.Iam looking for history tables in SYS schema.

What are they?What do they contain?Where are they used?

Ravi
Re: History tables [message #199553 is a reply to message #199548] Wed, 25 October 2006 01:45 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

In sys schema there is not "history table" in Oracle.
if you want to capture history then you create manually "history table".

Re: History tables [message #199555 is a reply to message #199518] Wed, 25 October 2006 01:53 Go to previous messageGo to next message
raviraviki
Messages: 135
Registered: May 2005
Senior Member
Any history tables in replication?
Re: History tables [message #199627 is a reply to message #199555] Wed, 25 October 2006 09:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10613
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Any history tables in replication?
This is a wild goose chase.
You need to ask a specific question.
Re: History tables [message #199631 is a reply to message #199555] Wed, 25 October 2006 09:49 Go to previous message
Mahesh Rajendran
Messages: 10613
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.
Previous Topic: Help required in finding Attribute Name
Next Topic: Can you tell me how to acess a table or procedure of another user in oracle.
Goto Forum:
  


Current Time: Sun Apr 20 04:23:50 CDT 2014

Total time taken to generate the page: 0.10254 seconds