Tables - names - all of them

[dd2k]

This may come across as seeming very ignorant or uninformed, but...
Can anyone tell me the names of the Oracle tables that Livelink addresses. All of them.

Background: I'm new to the system (it's hardly my field) and I'm stuck trying to glean as much information as I can from old LiveReports and pieces of SQL.

So far I've got:
DTree
DAudit
Kuaf
DVersData

but I need to know what else I'm dealing with.
Any help appreciated.
Cheers.

 

[appnair]

It will differ from installation to installation.There is a system schema reference that tells you the entity relationships and all that.It should be with your DBA.If you know the schema name and userid and password and if your DB is oracle you can see the listing by doing

SQL>select table_name from user_tables;

The best way is to look at data by creating an ODBC connection with access to your livelink schema and look at the data.You will understand a whole lot by looking at data.
The syetem schema reference basically will give you some xplanation on the columns et al.Hope this helps or post your email and maybe I can email you the different tables from version 8 and nine.I am not a datbase person per se but just by looking at the schema I have been able to muster LAPI/OScript things much better

 

[dd2k]

Brilliant appnair.
That's exactly what I was looking for - consider yourself owed an e-beer.

Cheers!