How To Dump or Restore Oracle DB With ODAC, i'am using ODAC Triall.
In Mydac using Component TADUMP
Thank's
Azis
Dump / Restore DB
Hello,
Unfortunately, ODAC doesn't have any components to backup or restore databases.
In ODAC you can save data into XML file by using the SaveToXML method of TOraQuery. Then you can load data into TVirtualTable using its LoadFromFile method. Then you can copy data to a table in the database using the LoadFromDataSet method of TOraLoader or the TCRBatchMove component.
You can also move data directly from one table to another using the TCRBatchMove component.
Unfortunately, ODAC doesn't have any components to backup or restore databases.
In ODAC you can save data into XML file by using the SaveToXML method of TOraQuery. Then you can load data into TVirtualTable using its LoadFromFile method. Then you can copy data to a table in the database using the LoadFromDataSet method of TOraLoader or the TCRBatchMove component.
You can also move data directly from one table to another using the TCRBatchMove component.