-
Hi all!
Query:
Working on Oraclev8i 8.1.6.0.0 with OS as NT.
1.Say I have to calculate the Avg.Row Length and Avg.Column Length of USER_CONS_COLUMNS
Table as under:
How should I calculate it to fix the correct BLOCK SIZE in order to avoid
Row migration and Row Chaining:
SQL> desc USER_CONS_COLUMNS
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER NOT NULL VARCHAR2(30)
CONSTRAINT_NAME NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
COLUMN_NAME VARCHAR2(4000)
POSITION NUMBER
2.I have created few users and those users would like to access the view USER_CONS_COLUMNS
under Balaji schema.Is it possible!.
The above users do not possess any schema objects.
How could I grant them select on BALAJI.USER_CONS_COLUMNS view so that the users from
their login ID would be able to view all the column_name,constraint_names of Balaji schema's
tables.
Provided that all the DB tables have been created in BALAJI schema and the users created
as above just have connect,resource,select,update,delete privileges
on Balaji.Table_names with them!
3.I am receiving the following error as under:
Connected to OEM : SYSMAN/PWD@biac-04
where biac-04 being the management server.
Conected to DB : SYSTEM/PWD@DB as SYSDBA.
Whenever I perform Export from OEM I get error status:failed!
Could you please let me know as to where I had goen wrong!
Thanks & Regards,
Amit.
-
answers
Query desc user_tables,in this table you will find both the columns required by you.
Please check the error log file after the export is done.It will tell you why the export has failed.
you dont need to give permission.The role connect,resource will by default give acess to these data dictionary objects for the user
regards
anand