How to Store database

[jeeseck]

Usually i will use dump operation to backup my database.
But if i need to retrieve the data which store in dump file ..i need to use load operation to load the dump file to database. It's need times to load the dump file ..

actually i will use some historical data in some tables only ...

How can i store my data besides using dump operation ?

Do u have any idea about this ...?

 

[RajD]

Hi jeeseck,

By this time, I hope you must have got solution to you problem.

Anyway, what appears from your question is that you need to "Dump" (backup) some or all data but restore only few of them as and when required.

If this is true, you may try 'bcp' as your backup/restore tool instead of dump.

I don't know exactly if that's what you are looking for.

RajD