Recent content by timofe

The key piece of information for my reports was that ci_application_systems joins to other views (e.g. ci_table_definitions) via ci_folder_members. For example: WHERE ci_folder_members.member_object = ci_table_definitions.id AND ci_folder_members.folder_reference = ci_application_systems.id...

Sorry. Maybe I didn't make myself clear. I'm trying to predict the size before any data is loaded. Will vsize work in this case? Thanks for your assistance.

Alex, Thanks, but I've already looked there. Why do Oracle do you a favour in one release and then take it away in the next release?! Frustrating is not the word... Cheers, Tim

Does anyone know how to calculate the size of a database row consisting of only NUMBER, DATE and VARCHAR2 columns in 8.1.7? There used to be a formula for 8, does it still apply (and, if so, can anyone remember what it is)?

I'm trying to copy a number of entities between applications in 6i. It doesn't like this much. If I try to copy more than one entity at a time it crashes out on me with non-existent reference errors. Am I doing something wrong? Cheers, Tim

I print to a postscript file then use something like GhostScript Viewer to save as a PDF. That makes the resulting file zoomable (which is VERY necessary for some of my models!) Cheers, Tim

Did you create them on an ERD, generate the tables from the entities and then delete the entities? If so, the tables would remain until you delete those as well. If not, look in the properties for the table and see if they are linked to any other entities, e.g. in another application system...

Are there such things as Read Triggers in Oracle 8i? My requirement is to write an entry to a transaction table every time a user views a row in a billable table (i.e. a pay-per-view system). It occurs to me that a row-level trigger based on the user reading an entry in the transaction table...