MySQL Forums
Forum List  »  Oracle

Oracle Structure equivalent to MySQL
Posted by: matthias.edrich
Date: December 15, 2004 11:05AM

Hi All,

In my organization we use MySQL and Oracle. Our main database is MySQL.
I am now programming a java application which copies all my MySQL tables
onto Oracle on a daily basis. Each day, I drop all tables in Oracle and build
them from scratch from what I get from MySQL.

For one of my functions, I use the "getTables()" method of the
"DatabaseMetaData" class. That method takes the following information.

getTables(String catalog,String schemaPattern,String tableNamePattern,String[] types)

I am quite successful leaving the "catalog" value as null as well as "schemaPattern."

However, what would be the equivalent in MySQL to the Oracle "catalog" and "schema"?

As you might tell, I am quite new to Oracle and have been living with
the very enjoyable MySQL database instead. But life catches up ;-)

Options: ReplyQuote

Written By
Oracle Structure equivalent to MySQL
December 15, 2004 11:05AM
December 26, 2004 11:02PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.