Re: how to move a schema to another tablespace...

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 14 Dec 2001 11:14:29 -0000
Message-ID: <3c19df1c$0$8510$ed9e5944@reading.news.pipex.net>

Yes

Connected to:
Oracle8i Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production

SQL> create table nltest(col1 varchar2(30)   2 )
  3 tablespace system;

Table created.

SQL> oops
SP2-0042: unknown command "oops" - rest of line ignored. SQL> alter table nltest move tablespace users;

Table altered.

SQL> select tablespace_name from user_tables where table_name = 'NLTEST';

TABLESPACE_NAME

---

USERS regards

NB indexes will need to be rebuilt as well.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************

"S-marty" <monkey_at_ludo.aa> wrote in message
news:9vcjtf$sgm4_at_ns4.bih.net.ba...


> Niall Litchfield wrote in message

> <3c187c2a$0$8510$ed9e5944_at_reading.news.pipex.net>...

> >Alternatively you

> >could use alter table blah move tablespace x in 8i and above.

> >

> Are you sure about this?

>
>
>

Received on Fri Dec 14 2001 - 05:14:29 CST