Re: Rollback segment and Tablespace questions

From: Chris Leonard <chris_at__N_O_.databaseguy._S_P_A_M_.com>
Date: Mon, 19 Aug 2002 15:15:54 -0500
Message-ID: <omc89.2668$wj.711547@news.uswest.net>

Hi David,

1. Look at the column OWNER in DBA_ROLLBACK_SEGS. It has the value 'SYS' for private rollback segments and 'PUBLIC' for public rollback segments.
2. What you're trying to do may be possible (though it looks like there would be some difficulties), but why? It seems like overkill. Is there a reason that the cursor approach won't work for you?

Hope this helps,
Chris

---

Chris Leonard
Brainbench MVP for Oracle Admin
http://www.brainbench.com

"David" <davidlee_at_diamond.com> wrote in message news:ajqqrc$klq2_at_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 - 15:15:54 CDT