Link to home
Start Free TrialLog in
Avatar of jung1975
jung1975

asked on

DBA_Extents script

SELECT * FROM DBA_EXTENTS WHERE OWNER='test AND EXTENT_ID>1

Can ypu tell me what this script does? i need to run it after the database backup...
I am runnning  oracle 8 on window
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
And, the version of Oracle (Oracle8 in your case) and the version of the server O/S (Windows) makes no difference.  This query works the same in any Oracle database on any O/S.
Avatar of jung1975
jung1975

ASKER

if the result found for query then, table must be rebuilt with larger size?
am i suppose to getting no data?
I just realized that there is an error in the query you posted.  It cannot run with "extent_id", that must be: "extents", then it can work.

No, you don't need to rebuild a table just because this query returns it.

If you get no data, that just means that one of these conditions is true:
1. There is no schema named: "test" (and if you run the query with lower case values ('test', not 'TEST') I would expect no rows to be returned because Oracle owner (schema) names are usually (if not always) uppercase values
2. The objects owned by 'TEST" all have only one extent (which is good).