Re: Few complicated Questions in Oracle

(1) Because it takes (n log n) time complexity to build a b*-tree structure whereas it only takes n time complexity when inserting rows into a linear list.

(2) No, it isn't. You won't get the proper locking and transaction mechanisms.

(3) It is useless and unnecessary unless done as a complete cold database backup because it may be written to at any time (remember that file headers may change). Further, the online redo logs are archived (if you run in archivelog mode) to the archive log files. This is normally very desirable because you can reconstruct your database from a (cold or hot) backup plus your archived redo logs. So the precise answer to your question is "no". But it is normally fine to run in archivelog mode and do a archive of the current log after a hot backup of the database (this means that the current log is archived prematurely).

Martin Haltmayer

Ram Prasad wrote:
>
> (1) Why creating an index is slower than creating a table ?
> (2) Is it posible for an instance on one server to mount the
> database on another server in the absense of OPS architecture
> - Using NFS mount technology ?
> (3) Is it beneficial to backup an online redo log file , In other
> words an we recover from the loss of an online redo log file using
> previous backup ? If not why ?
>
> Please mail your replies to tkrishna_at_baan.com
>
> Thanks in advance.
Received on Tue Feb 10 1998 - 00:00:00 CST