=?ISO-8859-1?Q?R=E9f=2E_=3A_RE=3A_move_tables_to_new

the problem is that i am working with 8i version .
what i did is :
alter table schema.table_name move tablespace new_tablespace ;

and when i check i see that the tables haved been moved to the new
tablespace but the space allocated is free.
is there a bug in this..?

david.

[Email address protected]
30/05/2007 15:18

Pour : DAVID.[Email address protected]
cc :
Objet : RE: move tables to new tablespace.

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text

EM in 10G & 9i have Reorganizer for tablespaces & schemas

You can Reorganize a table and put it in another tablespace;

10G EM

Tab Administration
Link Reorganize Objects

-----Original Message-----
From: David NGUYEN
[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

<html>

<head>
</head>

<body>


PLEASE NOTE:
Florida has a
very broad Public Records Law. Virtually all written communications to or
from
State and Local Officials and employees are public records available to
the
public and media upon request. The Seminole County Property
Appraiser (SCPA)
policy does not differentiate between personal and business emails.
E-mail sent
and received on the SCPA system will be considered public and will only be

withheld from disclosure if deemed confidential pursuant to State
Law.

</body>

</html>

Oracle LazyDBA home page

=?ISO-8859-1?Q?R=E9f=2E_=3A_RE=3A_move_tables_to_new_tablespace=2E?=

=?ISO-8859-1?Q?R=E9f=2E_=3A_RE=3A_move_tables_to_new_tablespace=2E?=