| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> rebuilding a table into another tablespace without reloading it
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-----
From: Glenn Travis [mailto:Glenn.Travis_at_wcom.com]
Sent: Wednesday, November 08, 2000 4:36 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Is there a way to determine which client connects (JDBC) ?
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
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 mayReceived on Wed Nov 08 2000 - 10:16:07 CST
 |
 |