Re: Scripts to re-create all elements

If I understand your question, the problem is that your comments are data in the data dictionary. The index file approach will recreate the dictionary, but not its contents, per se.

Editing export files is not supported by ORACLE. Some editors (in the old days, Wordstar in data mode, etc) can read/manipulate them, but doing so is at your own risk (Larry Elison will disavow any knowledge of your action.) (The problem is that there are lots of binary/integer numbers for field lengths that editor's today can interpret as end of file or automatically correct to printable characters, destroying the contents for Oracle.) If you have an editor that can read the file, then you will see that it is really nothing more than pre-SQL87 almost proprietary sql. Data can be retrieved for the various tables (including the data dictionary) using cut/delete/paste, if you are careful about string length.

The side problem is that this is not practical for large database or small editors.

You could try doing an import from a data export of the dictionary tables, or writing a script to extract the dictionary tables to an ascii file.

In article <3585178E.59BE6178_at_SPA-MM-tau.uab.es>,   Jordi Bellver <bellver_at_SPA-MM-tau.uab.es> wrote:
>
> > If you do an export for the database with ROWS=N, just a definition of
>
> > all the objects in the database will be generated.
>
> > Then if you do an import to an indexfile of the export file, an
> editable
> > script to create all the objects in the database will be generated.
>
> Excuse me for this 'incursion' but...
>
> Do you know what must I do to generate in this script the comments ?
>
> I do a export with FULL=Y, but when I make the import with INDEXFILE, I
> lost my 'comment' sentences. How can I include them in the script
> generated by import ? Are them in the data dictionary ? How can access
> them whitout a 3rt party application ?
>
> Thank's in Advance !
>
> bye
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Jun 17 1998 - 08:59:59 CDT