Re: [PHPLIB] "mysqldump" for Oracle From: Thomas Griffin (tgriffin <email protected>)
Date: 12/15/99

You can convert it to ascii. Use the "imp" command with the parameter
indexfile=<filename>. This will create an ascii file with all the create
table and index statements. The create table statements will be in remark
and the "REM" will need to be removed. Using the indexfile=<filename> will
not import the data into the database.

----- Original Message -----

On Tue, 14 Dec 1999, Kristian Köhntopp wrote:
}Does anybody here know of a way to get a "source code"
}representation from an Oracle database similar to
}what "mysqldump" produces?
}
}"mysqldump" produces a dump of a MySQL database in
}the form of a SQL script. This script, when run, recreates
}the database. I do not actually need the data in the
}database, but just the database model (i.e. create
}table, create index statements and the like).

From: "Alexander Aulbach" <ssilk <email protected>>
"exp" can be used to export it into an oracle-format, you can read it in
again with "imp". But there is NO program to export it in ascii like
mysqldump.

:-(

Perhaps a freeware-program anywhere? Or you can misuse sqlplus? E.g.

select 'insert into mytable values(' || col1 || ',' || col2 || ',' || col3
..... ||')' from mytable; 

--

SSilk - Alexander Aulbach - Herbipolis/Frankonia Minoris - (0931)22032

-
PHP3 Base Library Mailing List. Send messages to <phplib <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-request <email protected>> in
the body, not the subject, of your message.

-
PHP3 Base Library Mailing List. Send messages to <phplib <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-request <email protected>> in
the body, not the subject, of your message.