Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: MySQL / Oracle question
Scott_at_TheMattesFamily.ws said...
> It sounds like you want the export utility.
>
> You didn't say which OP SYS, but the filename is 'exp' and depending on the
> OP SYS there may or may not be a file extension.
>
> Look on tahiti.oracle.com for how to use.
>
> "Maximus" <qweqwe_at_qwqwewq.com> wrote in message
> news:tfNBa.112821$Vi5.3098303_at_news1.calgary.shaw.ca...
> > I bit the bullet and migrated from MySQL to Oracle, it all went quite well
> > and things are running tickety boo. One question though being an old
> > diehard MySQL user, is there an equivalent utility for Oracle that will
> dump
> > the schema and data from a table that works similar to the mysqldump
> > utility?
> >
> > Regards.
> >
> >
>
I had to lookup what mysqldump does at this url:
http://www.devarticles.com/art/1/62/2
From Mitchell's (the author's) description, it's exactly like the 'exp' utility that Scott refers you to (when you go over to tahiti, look for the Utilities Manual). One difference is that in Oracle terms, a MySQL database is an Oracle schema owner, so you don't have to do a full export (just for one user, the schema owner).
-- /Karsten DBA > retired > DBAReceived on Fri Jun 06 2003 - 11:28:14 CDT