Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Reverse engineer CREATE DATABASE sql
Niall Litchfield wrote:
> joel garry wrote:
> > Niall Litchfield wrote:
> > >
> > > parsing an export indexfile for DDL works on all versions and there is
> > > DBMS_METADATA as well (not without its bugs but hey you can't have
> > > everything.
> >
> > Could you post the exact commands for these? I don't know if I'm
> > braindead or what, but I don't see CREATE DATABASE.
>
> it's not you that's brain dead Joel but me.
>
> CREATE DATABASE isn't in the export file because, er that would be
> daft. I was reading the problem not as being recreate the (empty)
> database but recreate the objects in the db. DBMS_METADATA is a fun
> voyage, documentation and implementation :(
>
> As I think one of your notes points out the syntax for create
> controlfile and create database are remarkably similar, and for good
> reason. I think if I were looking purely to recreate the create
> database statement I'd start with BACKUP CONTROLFILE TO TRACE and a
> text editor.
I figured there was some misreading of the OP, but take it as a compliment and measure of esteem that I would consider a daft statement from you to make me question my own testing! :-)
jg
-- @home.com is bogus. Oh man, I wish I could see this: http://www.hollywoodbowl.com/tix/performance_detail.cfm?id=3022 Well, at least I saw the original tour.Received on Fri Aug 04 2006 - 16:54:29 CDT