How to move table from one tablespace to another in oracle 11g

by

Try this:-

ALTER TABLE <TABLE NAME to be moved> MOVE TABLESPACE <destination TABLESPACE NAME>

Very nice suggestion from IVAN in comments so thought to add in my answer

Note: this will invalidate all table’s indexes. So this command is usually followed by

alter index <owner>."<index_name>" rebuild;

Related Contents:

  1. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  2. How to create a new database after initally installing oracle database 11g Express Edition?
  3. Difference between oracle DATE and TIMESTAMP
  4. Hibernate dialect for Oracle Database 11g?
  5. Where does Oracle SQL Developer store connections?
  6. How to display databases in Oracle 11g using SQL*Plus
  7. ORA-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying
  8. How to uninstall / completely remove Oracle 11g (client)? [closed]
  9. How to create a user in Oracle 11g and grant permissions
  10. How to import an Oracle database from dmp file and log file?
  11. ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client
  12. ORA-28000: the account is locked error getting frequently
  13. Functions vs procedures in Oracle
  14. ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
  15. How to use Oracle’s LISTAGG function with a unique filter? [duplicate]
  16. Granting DBA privileges to user in Oracle
  17. How to find out when a particular table was created in Oracle?
  18. How can I describe a table in Oracle without using the DESCRIBE command?
  19. Creating a trigger in Oracle Express
  20. Explicitly set column value to null SQL Developer
  21. Oracle pl-sql escape character (for a ” ‘ “)
  22. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  23. How to list active / open connections in Oracle?
  24. Why are Oracle table/column/index names limited to 30 characters?
  25. UUID max character length
  26. How to get primary key column in Oracle?
  27. How to avoid variable substitution in Oracle SQL Developer
  28. ORA-01882: timezone region not found
  29. How do I turn off Oracle password expiration?
  30. Oracle difference between SID, DB Name, DB Domain, Global Database Name, Service Name, Service Alias and Instance Name
  31. Installing Oracle 32bit and 64bit client on the same machine
  32. Run Stored Procedure in SQL Developer?
  33. Oracle PL/SQL – Raise User-Defined Exception With Custom SQLERRM
  34. Oracle SQL Developer – Query results window with grid missing
  35. Finding last index of a string in Oracle
  36. How do I show running processes in Oracle DB?
  37. Find out the history of SQL queries
  38. Create a user with all privileges in Oracle
  39. ORA-01653: unable to extend table by in tablespace ORA-06512
  40. Oracle insert if not exists statement
  41. Find the server name for an Oracle database
  42. How to generate entire DDL of an Oracle schema (scriptable)?
  43. Find out free space on tablespace
  44. How do I change the default schema in sql developer?
  45. Is there a way to do full text search of all oracle packages and procedures?
  46. INSERT SELECT statement in Oracle 11G
  47. How do I view a Tree list of Schemas for a database in Oracle SQL Developer?
  48. Base64 encoding and decoding in oracle
  49. Passing an array of data as an input parameter to an Oracle procedure
  50. How to catch a unique constraint error in a PL/SQL block?

Leave a Comment