moving tables accross tablespaces

[dklloyd]

Hi there.
I need to move a load of tables from one tablespace to another.
Tablespace1 currently contains the tables that need to be moved and is the default tablespace of User1.

Tablespace2 is where the tables have to be moved to and User2 has grant resource privilege and has this tablespace as its default.

I'm logged on as system but when I try to move using, 'alter table user1.table1 move tablespace tablespace2;' I get the error "no privileges on tablespace 'tablespace2'"
Who needs what privilege to user or tablespace to carry this out as I thought that being system I could do this?

 

[carp]

The table owner needs the privilege, since the table resides in the tableowner's schema. Grant the table owner sufficient storage on tablespace2 and then try moving the table.