Results 1 to 2 of 2

Thread: Ora-12840

  1. #1
    Join Date
    Oct 2003
    Location
    southend-on-sea
    Posts
    3

    Angry Unanswered: Ora-12840

    I have created a materialized view in a local database based on a remote database. When I attempt to refresh this materialised view I get ORA-12840 Cannot access a remote table after parallel/insert direct load txn. However I have other materialized views based on the same database and dblink, which are refreshing ok. Is anyone able to throw some light at what is gooing on here.

    Thank you.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Ora-12840

    Whenever you use parallel or diect load inserts you have to commit before you can perform any further statements involving distributed access. So try issuing a COMMIT before this refresh.

Posting Permissions

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