Re: [Q] how to check objects on tablespace

From: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Wed, 24 Oct 2007 21:29:50 GMT
Message-ID: <iPOTi.47625$%B2.23757@edtnps82>

"aaa" <aaa_member_at_newsguy.com> wrote in message news:ffobl10199g_at_drn.newsguy.com...
> Can anyone tell me how to check any objects on tablespace (9ir2)?
>
> I check dba_objects but useless.
>
> Thanks.
>

If you want to know which objects are in a tablespace, you can use dba_segments.

-- 
Terry Dykstra

Received on Wed Oct 24 2007 - 16:29:50 CDT

This message: [ Message body ]
Next message: Mladen Gogala: "Re: [Q] how to check objects on tablespace"
Previous message: Mladen Gogala: "Re: EXP/IMP to a different tablespace: has anyone been able to solve this?"
In reply to: aaa: "[Q] how to check objects on tablespace"
Next in thread: Mladen Gogala: "Re: [Q] how to check objects on tablespace"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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