Home » SQL & PL/SQL » SQL & PL/SQL » Moving table from one tablespace to other.
Moving table from one tablespace to other. [message #312506] Wed, 09 April 2008 01:36 Go to next message
gauravsunil
Messages: 68
Registered: August 2007
Location: bhubaneswar
Member
Hi EXPERTS,

I am facing a problem..
I have to move a table from one table space to other.
Table is created in one tablespace but now on requirement
I have to move it to other table space.

Please help me on it....

Thanks in advance..

Regards,
Gaurav.
Re: Moving table from one tablespace to other. [message #312510 is a reply to message #312506] Wed, 09 April 2008 01:43 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
If you do a google search (or even a search in the documentation) then you wil easily fine the answer.
Re: Moving table from one tablespace to other. [message #312511 is a reply to message #312506] Wed, 09 April 2008 01:50 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
alter table "tbale_name" move tablespace "tablespace_name"
Re: Moving table from one tablespace to other. [message #312517 is a reply to message #312511] Wed, 09 April 2008 02:16 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Really, did you feel that the syntax was so difficult to find in the documentation that you had to detail it here rather than let the op work it out by searching for it? Spoonfeeding yet again.
Re: Moving table from one tablespace to other. [message #312524 is a reply to message #312506] Wed, 09 April 2008 02:33 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
How can you come to the conclusion that OP did not search?
WHAt is easy for you might be difficult for others.
Forums are for spoon feeding.
They ask because they need an answer.
As far i am concerned, if i know the answer i will tell it.
Re: Moving table from one tablespace to other. [message #312527 is a reply to message #312524] Wed, 09 April 2008 02:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Forums are for spoon feeding.

This is not the option we choosed here and you know it.
Read again forum guide.

Regards
Michel

[Updated on: Wed, 09 April 2008 02:47]

Report message to a moderator

Re: Moving table from one tablespace to other. [message #312528 is a reply to message #312506] Wed, 09 April 2008 02:47 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
But you can't help it.
90% questions are just like that in any forum.
Re: Moving table from one tablespace to other. [message #312533 is a reply to message #312524] Wed, 09 April 2008 03:02 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
You are NOT helping this person in the long run. What you are doing is making the person reliant on others doing their work for them. If you show them where to get the answer you are helping them, that way, the next time they have a basic question, they may be able to work it out for themselves, this is far, far more valuable than what you are doing just now. If you just spoon feed them the answer you are not assisting.
Re: Moving table from one tablespace to other. [message #312534 is a reply to message #312528] Wed, 09 April 2008 03:03 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
varu123 wrote on Wed, 09 April 2008 08:47
But you can't help it.
90% questions are just like that in any forum.

Bull. Where do you get this figure of 90%, let me guess, you just made it up.
Re: Moving table from one tablespace to other. [message #312535 is a reply to message #312528] Wed, 09 April 2008 03:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
varu123 wrote on Wed, 09 April 2008 09:47
But you can't help it.
90% questions are just like that in any forum.

This is wrong, 90% ( Wink ) of the answers are given in this way: hint, clue or links, and this helps, and in the long term. Wink

Regards
Michel

Re: Moving table from one tablespace to other. [message #312539 is a reply to message #312535] Wed, 09 April 2008 03:33 Go to previous messageGo to next message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
Michel Cadot wrote on Wed, 09 April 2008 10:13
varu123 wrote on Wed, 09 April 2008 09:47
But you can't help it.
90% questions are just like that in any forum.

This is wrong, 90% ( Wink ) of the answers are given in this way: hint, clue or links, and this helps, and in the long term. Wink

Regards
Michel




Has absolutely nothing to do with being right or wrong.
Just being helpfully: one helps by spoon feeding, one helps by giving hints, clues or links.

Maybe you should count the number of posts where you didn't give a direct answer but mere hints or clues that in the end didn't help the OP (because he/she didn't want to be helped that way, for sure).

I guess we're totally off-topic now Smile
Re: Moving table from one tablespace to other. [message #312547 is a reply to message #312539] Wed, 09 April 2008 03:59 Go to previous message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Has absolutely nothing to do with being right or wrong

Wrong was about: "But you can't help it". Maybe false was a better word, my english skills don't allow me to answer this.

Quote:
I guess we're totally off-topic now

Absolutly but topic was completly addressed, so...

Regards
Michel
Previous Topic: Merge command error
Next Topic: Trigger Problem
Goto Forum:
  


Current Time: Tue Dec 06 04:48:48 CST 2016

Total time taken to generate the page: 0.14953 seconds