problem in uploading data to the table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: problem in uploading data to the table

  1. #1
    Join Date
    Dec 2000
    Location
    Mumbai
    Posts
    38

    Angry

    I am getting this error while uploading the data to the database. On the same server I 9iAS is running. I am unable to shutdown the database.

    *
    ERROR at line 1:
    ORA-01116: error in opening database file 2
    ORA-01110: data file 2: '/delivery/datafile/Deliverydatafile.dbf'
    ORA-27041: unable to open file
    Linux Error: 1: Operation not permitted
    Additional information: 3

    ORA-06512: at "ESLDBA.UPLOADDELIVERY", line 83
    ORA-06512: at "ESLDBA.UPLOADDELIVERY", line 319
    ORA-06512: at line 1

    os=linux RH 7.2
    oracle: 9.0.1
    9iAS: 1.0.2.2.1

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    does the user you used to install Oracle have the rights on directory /delivery/datafile/ and on the file Deliverydatafile.dbf ???


  3. #3
    Join Date
    Dec 2000
    Location
    Mumbai
    Posts
    38
    the user has the right to write on these datafiles.
    I was able to upload data for 4 days all of sudden, I am facing the problem in shutdown. oracle is not shutdowning.

  4. #4
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Query DBA_DATAFILES and just check the status of this particular file.

    cheese
    anandkl
    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