1 2 Previous Next 17 Replies Latest reply on May 8, 2012 12:53 PM by 935233 Go to original post
      • 15. Re: Database link from one database to a remote database
        935233
        HI,
        I CAN ABLE TO CONNECT THE REMOTE DATABASE THROUGH DBLINK IE., SELECT * FROM MB_REG1@MBDATABASE.
        I HAVE GOT FOLLOWING PRIVILEGE ON LOCAL DATABSE

        SYSTEM PRIVILEGE:

        ALTER DATABASE
        CREATE ANY TABLE
        CREATE DATABASE LINK
        CREATE ANY MATERILIZED VIEW
        ALTER TABLESPACE

        OBJECT PRIVILEGE: NIL

        ON REMOTE DATABASE SELECT AND CREATE SESSION PRIVILEGE ARE GIVEN.

        AND MOREOVER I AM ACCESSING THE VIEW MB_REG1 THROUGH DBLINK.

        HELP ME OUT.....

        REGARDS

        NARAYANAN N
        • 16. Re: Database link from one database to a remote database
          900442
          Hi,
          The underlying view has errors. Please correct them before trying to create mv.
          *On the remote database*:
          
          SQL> create view tv2 as select N,O from test1;
          
          View created.
          
          SQL> alter table test1 drop column O;
          
          Table altered.
          
          SQL> desc test1
           Name                                                                                                              Null?    Type
           ----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------
           N                                                                                                                          NUMBER
          
          SQL> select * from tv2;
          select * from tv2
                        *
          ERROR at line 1:
          ORA-04063: view "REMOTE.TV2" has errors
          
          *On the local database*, creating MV will give the 4036 error:
          
          create materialized view tmv2 refresh complete as select * from REMOTE.tv2@LINK.TEST
                                                                                  *
          ERROR at line 1:
          ORA-04063: view "REMOTE.TV2" has errors
          HTH
          Raj..

          Edited by: rajkeshav on May 7, 2012 11:33 PM
          • 17. Re: Database link from one database to a remote database
            935233
            Hi,
            in the remote database i am accessing the view only and i have got select & create session privilege on remote database.

            Narayanan N
            1 2 Previous Next