Re: rebuilding a table into another tablespace without reloading

Yes, but...
what about PK, FKs, indexes, triggers, synonyms, grants & packages that might be associated with the original table?

Needless to say, it can be slightly more complicated than the response below indicates.

Hamid Alavi wrote:
>
> Do This,
> CREATE TABLE TABLEnew
> NEW TABLESPACE
> STORAGE()
> AS SELECT * FROM TABLEold
> -----Original Message-----
> Sent: Thursday, 9 November 2000 06:27
> To: Multiple recipients of list ORACLE-L
>
> Hi,
>
> does some one know of a way to rebuild a table into another tablespace as it
> is now? I loaded the data into the database, but the default tablespace was
> set to the wrong one. Rebuilding indexes in an other tablespace was easy,
> but how can I do the same to tables without having to drop and reload the
> user.
>
> Any help will be appreciated.
>
> Regards,
>
> Tamas Szecsy
>
> -----Original Message-----
> Sent: Wednesday, November 08, 2000 4:36 PM
> To: Multiple recipients of list ORACLE-L
>
> We use WebLogic as our app server. The app server runs on coco and scully.
> Here is on of the queries I use; (output follows).
>
> select USERNAME,
> OSUSER,
> machine,
> PROGRAM,
> STATUS,
> type,
> module
> from sys.v_$session
> where USERNAME is not NULL
> order by USERNAME, OSUSER
>
> USERNAME OSUSER MACHINE PROGRAM
> STATUS TYPE MODULE
> ------------ ------------ ------------------------- ------------------------
> ------ ---------- ------------ --------------------
> ESP Ashish ASHISH Toad.exe
> INACTIVE USER T?O?A?D?
> ESP ron ES_WKSTN1 SQLPLUSW.EXE INACTIVE
> USER SQL*Plus
> ESPADMIN esp scully java_at_scully (TNS V1-V3)
> INACTIVE USER
> ESPADMIN esp scully java_at_scully (TNS V1-V3)
> INACTIVE USER
> ESPADMIN weblogic coco java_at_coco (TNS V1-V3)
> INACTIVE USER
> ESPADMIN weblogic coco java_at_coco (TNS V1-V3)
> INACTIVE USER
> ESPADMIN weblogic coco java_at_coco (TNS V1-V3)
> INACTIVE USER
> ESPADMIN weblogic coco java_at_coco (TNS V1-V3)
> INACTIVE USER
> SYSTEM oracle hampton sqlplus_at_hampton (TNS
> V1-V3) ACTIVE USER 01@ sessinfo2.sql
>
> > -----Original Message-----
> > From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Ronen Levit
> > Sent: Wednesday, November 08, 2000 4:35 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Is there a way to determine which client connects (JDBC) ?
> >
> >
> > When the application server (in my case weblogic) using connection pool to
> > connect the db, it leaves no signs of
> > which machine connected to the db. Is there a way to find out the machine
> > from which the jdbc connection was made?
> >
> > All the info I've got from such connection is
> > OSUSER = jdbcuser
> > COMMAND = unknown
> > MACHINE = jdbcclient
> > PROGRAM = JDBC-1.0-Client
> >
> > Thnx,
> >
> > Ronen Levit
> > Database team leader
> > www.talmai.com
> > T: +972 8 9460606 #212
> > F: +972 8 9460705
> > C: +972 52 448699
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ronen Levit
> > INET: ronen.levit_at_talmai.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Glenn Travis
> INET: Glenn.Travis_at_wcom.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Szecsy Tamas
> INET: tszecsy_at_GEOMETRIA.hu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
> INET: HamidA_at_aimdirect.co.nz
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Charlie Mengler               Maintenance Warehouse  
charliem_at_mwh.com              10641 Scripps Summit Ct