Re: Generating CREATE_DB script - how?

Sorry the correct statement is:

  SQLDBA> alter database backup controlfile to trace;

This creates an ascii file on your hard disk. I don't remember the filename but it can easily be found by listing date and time.

Asim Aslam
DBA/Developer
BMC
>
> Try in sqldba ...
>
> ALTER DATABASE BACKUP CONTROLFILE TO 'filename'
>
> This would create a file. View and modify the file and run it. If I
 remember
> correctly the database have to be closed but mounted.
>
> Asim Aslam
> DBA/Developer
> BMC
>
>
>
> >
> > Hello,
> >
> > I'm pretty sure that there's a way to generate, from an open
> > database, a SQL script to CREATE that database's structure.
> > I'd like to generate this script before I drop the database,
> > so that I can recreate the structure easily. Does anybody out
> > there know of a way to generate this SQL script?
> >
> > Thanks in advance for your help.
> >
> > Chris Little
> > Oracle DBA, GE Fanuc Automation, Charlottesville, VA
> >
> >
>
Received on Fri Sep 29 1995 - 00:00:00 CET