Re: Security question

Assuming all filesize are still the same, and a file clauses include = reuse, the create database statement will overwrite the existing = database. I did that at least once, and on purpose. If filesizes differ = the statement will fail. You might however see unexpected results as = this statement is usually wrapped in a batch of scripts recreating = everything. The script will definitely continue.

Hth,
Sybrand Bakker, Oracle DBA

    sam.petitto_at_netsec.net wrote in message = <376E66D1.8940629A_at_netsec.net>...

    Would issuing the a CREATE DATABASE statement in the DBA role on an = existing database my_database completely destroy my_database ? If not, = what would be the result ?

    --
    =

    Sam Petitto
    Database Engineer
    Network Security Technologies, Inc.     www.netsec.net
(877)799.9380 Toll Free
(703)561.0420 Local
(703)561.0426 Fax

    =

    This electronic message contains information from Network Security     Technologies, Inc or its affiliates, which may be confidential,     proprietary or otherwise protected from disclosure. The information = is

    intended to be used solely by the recipient(s) named above for the     purposes intended by the originator. If you are not an intended     recipient, be aware that any review, disclosure, copying, = distribution

    or use of this transmission or its contents is prohibited. If you = have

    received this transmission in error, please notify us immediately by =

    telephone at (703) 561-0420, or by electronic mail at = sales_at_netsec.net        Received on Mon Jun 21 1999 - 12:54:18 CDT