Problemas con el backup online

Colapsar
X
 
  • Tiempo
  • Mostrar
Limpiar Todo
nuevos mensajes
  • aldologatto
    Junior Member
    • ene
    • 12

    #1

    Problemas con el backup online

    Buenas a todos, gente estoy teniendo un problema con el backup online, aca les dejo el log de error, no pude encontrar nada al respecto, si me ayudan se los voy a agradecer!!!

    BR0051I BRBACKUP 6.40 (47)
    BR0055I Start of database backup: bdxpayoy.anf 2008-03-30 12.17.08
    BR0484I BRBACKUP log file: /oracle/TIQ/sapbackup/bdxpayoy.anf
    BR0280I BRBACKUP time stamp: 2008-03-30 12.17.08
    BR0301E SQL error -942 at location BrDbConnect-4
    ORA-00942: table or view does not exist
    BR0310E Connect to database instance TIQ failed
    BR0280I BRBACKUP time stamp: 2008-03-30 12.17.08
    BR0301E SQL error -942 at location BrDbConnect-4
    ORA-00942: table or view does not exist
    BR0310E Connect to database instance TIQ failed
  • spanishpower
    Member
    • ene
    • 80

    #2
    Bueno pues el error ORA-00942 es este segun la pagina ORACLE ...


    ORA-00942: Table or view does not exist
    The table you are trying to access does not exists, or you do not have privileges to access the table.

    You can use following select to determine if you have access on the table:

    select owner, object_name, object_type
    from all_objects
    where object_name='<table_name> or <view_name>'

    If you do see the table/view in the previous select, you might need to add the owner in front of the table/view name.

    select * from owner.object_name

    If you have to add the owner in front of the name, you can consider creating a synonym.

    create synonym synonym_name for owner.object_name.

    From now on you can just select from the synonym name (which is usually the same name as the table/view name).

    If you do not have privileges on the table or view, grant the necessary privileges as the owner of the object:

    grant select on object name to privileged user



    Espero te sirva de ayuda .....

    Saludos

    Comentario

    Trabajando...