Re: How to check if AUD$ is in the SYSTEM tablespace?

select tablespace_name from dba_tables
where owner = 'SYS' and table_name = 'AUD$';

This is very basic, Grace, are you sure you want to do this migration by yourself?
(I'm not joking)

Kind regards,

Gerard

Grace Tsai heeft geschreven in bericht <3720B071.853A296E_at_bnl.gov>...
>I am preparing to upgrade our Oracle7 to Oracle8, and I downloaded the
>"Unix Migration Checklist For Customer Use" from ORACLE MetLink.
>
>One of the steps in "Prepare Database for Migration" is
>
>"Make sure AUD$ is in the SYSTEM tablespace if database auditing is
>ebabled"
>
>My question here is
>How to check if AUD$ is in the SYSTEM tablespace?
>
>Thanks in advance.
>
>Grace Tsai
>Brookhaven National Lab
>
>
Received on Fri Apr 23 1999 - 15:56:18 CDT