Table space for Oracle Mobile table

1. Modificationsthe space of the tableALTER TABLE table_name move tablespace tablespacenamequerying all tables under the current userselect ' ALTER TABLE' | | | table_name | | 'move tablespace tablespacename; ' fromUser_tables;2. ModificationsThe index space of the tableALTER index index_name rebuild tablespace tablespacenamequerying all indexes under the current userselect ' Alter index ' | | | index_name | | ' rebuild tablespace tablespacename; ' fromuser_indexes

Log table is not suitable for mobile

Set Linesize 200
Col table_name format A5
Col column_name format A5
SELECT B.table_name,
A.segment_name,
B.index_name,
A.segment_type,
B.column_name,
A.tablespace_name,
B.chunk,
B.cache,
B.freepools,
B.pctversion,
B.retention
From dba_segments A,dba_lobs b
WHERE A.segment_name = B.segment_name
and a.tablespace_name = ' TEST '

Table space for Oracle Mobile table