IF YOU ARE IN 8.1.6 AND ABOVE YOU CAN ACTUALLY MOVE THE TABLE TO ANOTHER
TABLESPACE JUST BY GIVING THE COMMAND ALTER TABLE MOVE TABLESPACE. this
might even work for 8.1.5 i dont know i havent tried
Well i have done this for a small table i dont know about large tables
if you do this u do not have to change anything on the dictionary side i
mean about the user u are talking about.
>From: Hamid Alavi <HamidA_at_aimdirect.co.nz>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: rebuilding a table into another tablespace without reloading
>Date: Wed, 08 Nov 2000 14:06:42 -0800
>
>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).
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com.
Received on Wed Nov 08 2000 - 16:52:32 CST
