DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: OEM export fails!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    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.

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840

    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
    anandkl

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width