Oracle vocabulary, what is the mysql/mssql equivalent of a database
Posted
by jeph perro
on Stack Overflow
See other posts from Stack Overflow
or by jeph perro
Published on 2010-04-22T16:22:04Z
Indexed on
2010/04/22
16:23 UTC
Read the original article
Hit count: 419
Hi,
I need some help with vocabulary, I don't use Oracle that often but I am familiar with MySQL and MSSQL.
I have an application I need to upgrade and migrate, and part of the procedure to do that involves exporting to an XML, create new database tables, then populate the new database tables from the XML export.
In Oracle, my database connection specifies a username, password, and an SID.
This SID contains tables belonging to several applications.
My question is: Can I re-use the same user to create the new tables ( with the same names ).
In MySQL or MSSQL, I would create a new database and grant my user privileges to create tables in it.
OR, do I need to create a new database user for my upgraded tables?
© Stack Overflow or respective owner