Home » Developer & Programmer » Data Integration » Referential Intergrity and Data Warehousing
Referential Intergrity and Data Warehousing [message #93150] Mon, 24 March 2003 05:17 Go to next message
Messages: 1
Registered: March 2003
Junior Member

I want to archive / store offline in a spererate location, the contents of a large table in my database.
I have noticed that it has relationships with a number of other tables - however,I need to know 2 things :

1.If i remove the contents of this table, will it have an effect on the other tables and therefore the integrity of the data
2.Can anyone reccommend a graphical tool for viewing the relationships between tables
3.The best way to archive / store this data

Many thanks in advance
Re: Referential Intergrity and Data Warehousing [message #93159 is a reply to message #93150] Thu, 24 April 2003 16:33 Go to previous message
Lars Sjöström
Messages: 24
Registered: June 2001
Junior Member
If you remove the table and there are related data it will surely effect integrity.

Toad is a good tool for reviewing relationships between tables. You can reengineer the data model if, and only if, there are constraints in the database.

The best way to archive / store data I do not know. Sorry.
Previous Topic: Multiple data files in 1 external table
Next Topic: oracle data warehouse
Goto Forum:

Current Time: Sat May 18 12:24:41 CDT 2024