On 11/9/06, ViSolve DB Team <[EMAIL PROTECTED]> wrote:
Hi Experts,
We are in the process of converting Oracle administration commands into MySQL
for some purposes. We dont know how to convert the following Oracle commands to
MySQL. How to do that..?
1. ALTER USER spec TEMPORARY TABLESPACE temp_ts;
There's no equivalent concept in MySQL to a temp tablespace. The key
with them in Oracle is actions performed in a temp tablespace aren't
logged (sorts and hashes that overflow the memory), and the files that
constitute them aren't required for recovery.
2. DROP USER jbossjms1 CASCADE;
No equivalent to the cascade option ... so create a script-generating
script, or drop the database if you've equated schema with database.
3. DROP TABLESPACE jbossjms1 INCLUDING CONTENTS;
You normally don't need to muck around with a storage engine's
low-level tablespace management. You might want to work out what
objects this would drop, and do that instead.
4. CREATE TABLESPACE jbossjms1DATAFILE '${JBOSSJMS1}' SIZE 100M REUSE
AUTOEXTEND ON MAXSIZE UNLIMITED;
Ensure the files in your innodb_data_file_path have the autoextend
property set, and total atleast 100MB in size. The Oracle syntax
above uses ASM-based storage, which has no equivalent in MySQL, so
forget that bit
5. CREATE USER jbossjms1 IDENTIFIED BY jbossjms1DEFAULT TABLESPACE jbossjms1;
As per normal user creation ... just ignore the tablespace bit.
Ciao
Fuzzy
:-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
