Skip to Content
avatar image
Former Member

Importing the SAPDBA role (sapdba_role.sql)

Hi Experts,

i am Importing the SAPDBA role (sapdba_role.sql) in my system before 12 hours still it is runninig , i want to know how much time it wil take.

Thanks in Advance!

Rgds,

Vishal Borisa

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 02, 2010 at 09:37 AM

    Hello

    Are you doing the following steps?

    Update the SAPDBA role as <dbsid>adm user as follows:

    a) Copy sapdba_role.sql from the DIR_CT_RUN directory to the %ORACLE_HOME%\database directory.

    b) Execute the following SQL command(s):

    sqlplus /nolog @sapdba_role <SAPSCHEMA_ID>

    As far as I remember, this did not take more than 5-10 minutes.

    Regards

    Anindya

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 06, 2010 at 12:08 PM

    Thank You very much for reply immediate.

    Rgds,

    Vishal

    Add comment
    10|10000 characters needed characters exceeded