Search results for query: *

Hi Dave, Thanks for the quick reply... even if it wasn't the answer I was looking for! As for using CLOB/BLOB over LONG, not much I can do about that seeing as the database is part of a SAP ERP system. Thanks again. Sarah J PS: I liked your analogy with the character lenny from the book "Of...

Hi, I work in a SAP environment where the backend database is Oracle 9i. I use SAP's SAPDBA tool when reorganizing/re-building tables and indexes. The SAPDBA tool uses Oracle's Export & Import command, along with Drop & Create SQL scripts to do the re-builds. Everyting is taken care for you by...

Sorry Dave, there was one more thing... after addressing my question above regarding required archive logs, could you also please tell me the sequence of commands to start up the database after restoring the necessary files from the On-line backup tape? Thanks Sarah of London, UK.

Hi Dave of Sandy, Utah, USA! (aka Mufasa) Thanks for a very comprehensive explanation. Had to read it several times though to get my head round it!… I have a couple of DBA books but none of them seem to go into it in any great detail. At least I understand also now why (in your own words)...

Hi, can some one recommend a good source of information regarding online backups and in particular restoring from an online backups? You see I don't totally understand what goes on internally within Oracle when tablespaces are put into hot backup during an Online backup. For example how are...