MySQL – Table space Error issue
Asked By 40 points N/A Posted on - 06/13/2011
I was working with MySQL server along with oracle database and was coding it a bit. After coding when I ran MySQL Server along with the oracle database to get attached, I got this error message of Table Space creation. I know how to code into MySQL files and oracle files and did it correctly, but can’t figure out why this error occurs.
As a solution, I tried re-coding the files and rolled back the table space name so that it may help me out but it really didn’t work. This is the command I changed after the error
Mysql> CREATE TABLESPACE ts2 ADD DATAFILE ‘datafile2.dat’ USE LOGFILE GROUP 1g1
INITIAL_SIZE 12M ENGINE NBD;
After this change, I restarted the server and the reconnected the database, but after a pause the error re-appeared. Could someone resolve this error for me?
Tablespace create failed with error:
Do you want to continue creating other tablespaces?