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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
if the result found for query then, table must be rebuilt with larger size?
am i suppose to getting no data?
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).
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).