Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Rollback segment and Tablespace questions

Rollback segment and Tablespace questions

From: David <davidlee_at_diamond.com>
Date: Mon, 19 Aug 2002 21:15:49 +0800
Message-ID: <ajqqrc$klq2@imsp212.netvigator.com> 





hi all, I have two questions about Oracle (oracle8i 8.1.7)



i) how can I find the rollback segment is public or private (from which data
dictionary)?


ii) I found (from Oracle Metalink, Note:1020180.6) that I can create "CREATE
TABLESPACE" SQL statement by using cursors. Is it possible to generate the
"CREATE TABLESPACE" SQL statement by using one SQL statement (without using
cursors)? The difficult part is how to join dba_tablespaces and
dba_data_files into one statement if the tablespace has more than 1 data
file.



David
Received on Mon Aug 19 2002 - 08:15:49 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US