Re: how to make a backup sql file for my database??

From: <sybrandb_at_yahoo.com>
Date: 30 Jun 2003 00:55:49 -0700
Message-ID: <a1d154f4.0306292355.5fa4acf2@posting.google.com>

"myhome" <myhome_at_home.hk> wrote in message news:<3eff9ca8_at_shknews01>...
> I have a database in Oracle 9i. I want to backup the structure and data in
> some *.sql file. Can sqlplus do this purpose for me?? and How to do?
>
> Thx

with standard Oracle facilities:
lookup how to export a database in the Oracle Server Utilities Manual Then lookup how to create a sql file in thes same manual by using imp show=y log=<file> or indexfile=<file>

There should be no need to do this however, because using proper development procedures tables aren't created on the fly.

Don't expect this group will function as a replacement for reading manuals

Sybrand Bakker
Senior Oracle DBA Received on Mon Jun 30 2003 - 02:55:49 CDT