Re: [PHPLIB] "mysqldump" for Oracle From: Alexander Aulbach (ssilk <email protected>)
Date: 12/15/99

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).

"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.