Re: database export ??

Cristian Perez Bravo wrote: > > Hello : > > I got a question . > > Anybody knows to come down a database to plain text. ?? > > Something like the command dbexport for Informix ?? > > The answer can send it to cperez@ra.usach.cl or cperez@moai.usach.cl. > > Thanks ... The export tool does not generate exaclty plain text. It is possible to edit it if you wanted to depending on the size and amount of data. It most likely would be simplier to use SQL*PLUS to extract the tables using the spooling to separate the tables into separate files. Although I have never specifically done this, one could utilize the system tables like all_tables and all_table_columns (I think), etc to determine on the fly the content of the tables, indexes, etc. Obviously, other Oracle objects like security, roles, triggers could be done the same way. Forms and reports and possibly stored procedures do not translate well into "plain text" Mike K.