Current Position:Home > Dba_segments view is gone

Dba_segments view is gone

Update:11-30Source: network consolidation
Advertisement
I'm not sure how or when this occured. This is our test server and it is a "Bi-continuous Volumne" (bcv) of the production server. (EMC Clustered environment) The bcv is a disk-level copy of the production server. Basically it copies all clustered files at the disk level and you just plug the bcv into another server and create a copy of your production server. We've had alot of issues pop up over time (and two bcv's).
The dba_segments view does not exist at all. I can do a describe on a number of other dba_ views but for some reason this view doesn't exist. How do I recreate this view and how would I check for any other missing views/tables that we may have not noticed? Thanks for any help.

The Best Answer

Advertisement
SQL> select owner,object_type from dba_objects
  2  where object_name = 'DBA_SEGMENTS';
OWNER                          OBJECT_TYPE
SYS                            VIEW
PUBLIC                         SYNONYM
SQL> DESC SYS.DBA_SEGMENTS
Name                                      Null?    Type
OWNER                                              VARCHAR2(30)
SEGMENT_NAME                                       VARCHAR2(81)
PARTITION_NAME                                     VARCHAR2(30)
SEGMENT_TYPE                                       VARCHAR2(18)
TABLESPACE_NAME                                    VARCHAR2(30)
HEADER_FILE                                        NUMBER
HEADER_BLOCK                                       NUMBER
BYTES                                              NUMBER
BLOCKS                                             NUMBER
EXTENTS                                            NUMBER
INITIAL_EXTENT                                     NUMBER
NEXT_EXTENT                                        NUMBER
MIN_EXTENTS                                        NUMBER
MAX_EXTENTS                                        NUMBER
PCT_INCREASE                                       NUMBER
FREELISTS                                          NUMBER
FREELIST_GROUPS                                    NUMBER
RELATIVE_FNO                                       NUMBER
BUFFER_POOL                                        VARCHAR2(7)Did some one drop a public synonym?
  • New tables & indexes created do not show up in dba_segments view Update:10-11

    Dear all, I have created 3 tables and some indexes, but these objects do not show up in dba_segments view. Is this a normal behaviour? Previously, with dictionary managed tablespace, I can specify the minimum extent to create, when the table/index is

  • DBUA fails due to broken DBA_SEGMENTS view during 10.1.0.4 - 10.2.0.2 upgr Update:11-30

    Hi, I'm upgrading 10.1.0.4 to 10.2.0.2 by cloning a 10.2.0.2 ORACLE_HOME (runInstaller -clone), running the pre-upgrade info tool (utl102i.sql) and finally running the dbua. Once I select the database to upgrade and then Next>, the dbua GUI reports &qu

  • Dba_segments view is gone Update:11-30

    I'm not sure how or when this occured. This is our test server and it is a "Bi-continuous Volumne" (bcv) of the production server. (EMC Clustered environment) The bcv is a disk-level copy of the production server. Basically it copies all cluster

  • DBA_SEGMENTS view not showing the current size of the tables Update:11-30

    we are querying the dba_segments view for checking the size of some table in our DB, but even though the no. of rows are increasing the size of the tables (acc to dba_segments) is same. we also checked with the last analyzed attribute but even after

  • Getting ORA-01403 in dba_segments query during a trigger Update:11-30

    Hi, Everyone -- I need to set up a process which will automatically start Oracle auditing on a table when it's created on a particular tablespace. I've created an "after create on database" DDL trigger which will fire when (ORA_DICT_OBJ_TYPE = '

  • Undable to drop tablespace ORA-01561: failed to remove all objects in the Update:10-11

    hi, i am unable to drop table tablespace how can i do that?? please advise DROP TABLESPACE tbs_tp2 INCLUDING CONTENTS AND datafiles ERROR at line 1: ORA-01561: failed to remove all objects in the tablespace specified Thanks in advance siva chennaiHav

  • How to find OWNER of the table- if user doesn't have a access to it? Update:10-11

    I am in the strange situtation- that I need to make a configuration script to give to DBA so that he can give necessary access to to populate the data into the application. However- he needs exact sql scripts so that he can run it without manupulatin

  • How to calculate the percentage of free space for a table in Oracle Update:10-11

    okay, I am a little confused here. I have been searching the web and looking at a lot of documents. What I basically want to find out is this, how do I calculate the difference between the number of bytes a table is using and the total bytes allocate

  • Report with top 10 tables ... Update:11-30

    Hello ! I need to create an report with the top 10 tables : 1 - The most bigger tables 2 - The most access tables 3 - The bigger number of sorts 4 - The physical access 5 - The bigger shared memory use The first one i can get from dba_segments, but t

  • TableSpace Objects and Size Update:11-30

    Hello Oracle Community, DB: 11.1.0.7.0 How can I see what database objects (tables, indexes, etc.) are stored in a given tablespace and what is the best way to shrink the size of a tablespace/datafiles ? IKrischerYou can see the mapping of objects to