Re: Tool for versioning of Data in data base

Kamal,

If I understood your question well, You would like to have a trail of changes on certain tables.

If this is the case you can achive under 10G by Auditing and Flash Back.

Auditing you can do on the older versions of oracle but the Flashback is a feature of Oracle 10G.

As if you have to know all changes to a schema, you can monitor billing table.

eg. >> audit UPDATE on xyz.billing by access;

View DBA_FGA_AUDIT_TRAIL can display DML statements in addition to Select.

Nisar Tareen

kamal.reddy_at_gmail.com (Kamal) wrote in message news:<b0ad5ab.0411111746.3c5fe128_at_posting.google.com>...
> Hello group,
>
> Can any one pls answer this question?
>
> -> Similar to Documentum which is used for versioning, workflow,etc of
> documents through API ( i mean has APi interface too), Is there any
> other product or tool using which i can do version of data in a
> relational database(ex. orcale).
>
> I guess the functionality of the product/tool would be
> -build repositories for teh given database schema and
> -vesions the changes to the database as given in the properties
> - has an API using which we can use teh features of teh tool
> programatically.
>
> or smthing like that. Ur inputs are highly appreciated.
>
> Thanks,
> Kamal
Received on Tue Nov 16 2004 - 17:25:32 CET