Creating a database link on start up

[dhaveedh]

Hi Everyone,

I am building a database that will be accessing a large dataset when it is produced at the end of the month. This dataset is required to enable us track performance on a weekly basis until the next large dataset is produced and the previous one archived.

I do not want the database I am building (working database) to permanently store this large dataset due to space constraints and also due to the fact that it will also have its own other large tables and backend database. So I have created a separate database to only hold the data.

I want to create a link to this datastore only when my working database is loaded so that it only temporarily uses resources when the database is active.

Does anyone know code that can help me create this link when the database is opened up and then closed when the database is closed.

I hope this is a bit clear?




KISS - Keep It Simple Sugar!

 

[lupins46]

What is the problem with just linking to the database?

 

[dhaveedh]

Space constraints on the network drive.

The databage i could have linked to has one table and it is already 110MB. The working database I am building already has a capacity of 98MB and grows to 150MB once I create the link to this database.

I was just wondering if this could be done so that the disk usage is reduced freeing up space for other things.

Ta

KISS - Keep It Simple Sugar!

 

[lupins46]

Have you run a compact on the database?
Linking to a table should cost you very little (a few Kb at most).