Re: extracting metadata

In article <newscache$r161cg$i77$1_at_localhost.localdomain>, =?iso-8859-1?Q?Sven_Sch=E4fer?= <s.schaefer_at_bmi-heidelberg.com> writes:
>Hello,
>I extracted the metadata of an Oracle DB with export. Unfortunately the
>content of the file isn't human readable. Because I would like to reuse
>the metadata with slight changes on another machine it would be nice to
>have all the information in ascii. Interbase can do this. Is there also
>a way in oracle to achieve this? Are there any other tools?
>
> Greetings
>
> Sven
>

Sven, look in the utilities manual for the import utility, imp, and look at the parameter indexfile to see if this will help you.

Otherwise the dictionary views sys.dba_tablespaces and sys.dba_data_files plus the dynamic performance views v$log, v$logfile, and v$controlfile pretty much give you the structure of the database.

• Mark D. Powell --
  • Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net