Re: Generating CREATE_DB script - how?

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