MySQL Forums :: Newbie :: How to create TableSpace


Advanced Search

How to create TableSpace
Posted by: Nalini R Rajan ()
Date: August 13, 2010 12:47AM

Dear all,

I have Server version 5.1.35-community via TCP/IP and Client version 5.1.11

I have default schema called SuHar

I want to create a TableSpace in that schema.

I used the syntax.

CREATE TABLESPACE core ADD DATAFILE 'suharcore' USE LOGFILE GROUP suharcorelog

It gives error -

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

How do I proceed ?

Thanks for ur help in advance

Regards,
Nalini

Options: ReplyQuote


Subject Written By Posted
How to create TableSpace Nalini R Rajan 08/13/2010 12:47AM
Re: How to create TableSpace Rajkumar D 08/13/2010 02:58AM
Re: How to create TableSpace Nalini R Rajan 08/13/2010 05:42AM
Re: How to create TableSpace Rajkumar D 08/13/2010 05:45AM
Re: How to create TableSpace Rajkumar D 08/13/2010 05:47AM
Re: How to create TableSpace Nalini R Rajan 08/14/2010 07:13PM
Re: How to create TableSpace Rajkumar D 08/15/2010 10:12PM
Re: How to create TableSpace Rajkumar D 08/15/2010 11:26PM


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.