we work with 8i version .
when we move tables to new tablespace , i suppose that tables and rows
will be moved together.
it s really strange
david.
oracledba-ezmlmshield-x15399564.[Email address protected]
30/05/2007 14:41
Pour : [Email address protected]
cc :
Objet : RE: move tables to new tablespace.
10g?
Recyclebin?
Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546
-----Original Message-----
From: David NGUYEN
[mailto:oracledba-ezmlmshield-x8468044.[Email address protected]
Sent: Wednesday, May 30, 2007 5:23 AM
To: LazyDBA Discussion
Subject: move tables to new tablespace.
hello experts,
i followed your advice to move tables from tbs1 to tbs2, the moved
tables
are on the new tablespace(tbs2) but the space allocated is empty on he
new
tablespace and on the old tablespace the space always is full...
any ideas about this..?
thanks
david...
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page