Problem regarding modification of global name and with import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Problem regarding modification of global name and with import

  1. #1
    Join Date
    Oct 2001
    Location
    Calcutta , India
    Posts
    78
    Hallo ,
    I am in deep problems which are as follows

    case 1: I am trying to change global_name of a database using
    ALTER DATABASE RENAME GLOBAL_NAME TO 'B.B.C' this sql statement.
    Currently global_name is 'A.B.C' and I want to change to 'B.B.C'. Then I found one problem -
    "ORA-01729 database link name expected". After that I queried
    dba_db_links and I found that there are 2 loopback database links
    having the same name "A.B.C" but one is public and another one is
    private . When I am trying to drop these links using DROP DATABASE
    LINK A.B.C then the error message is "ORA-02082 a loopback database link must have a connection qualifier ". So what is the solution?
    How to drop these 2 links and modify the Global_name ?

    case 2 : We do export and import every night . It continued for last
    2 years . Suddenly after changing the archive mode of the database ,
    when I am trying to import that dmp file in another database it is
    giving error IMP-0008 .This method we have been using for the last 2 years. If we export and import the scott user then it is running fine
    , but in case of other users ( which are actually needed ) the error
    is coming. what is the reason and solution ?

    I NEED HELP VERY URGENTLY

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    1. Do the following:

    alter database rename global_name to JULIAN;

    select * from global_name;

    drop public database link 'A.B.C';

    alter database rename global_name to 'new_name';

    or

    update GLOBAL_NAME set GLOBAL_NAME = 'new_name';

    Is the init.ora parameter global_names = true? Was the db link created without a domain?

    2. Do you take full EXP?




  3. #3
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    As for question#2:
    follow up to Julian's question. Maybe you
    take a full backup and that your O.S. limit size is reached.
    If this is the case, then you have to take an individual
    export per user.

  4. #4
    Join Date
    Sep 2005
    Posts
    1
    If I do an
    ALTER DATABASE RENAME GLOBAL_NAME TO 'anything'
    ORA-01729: nombre de enlace de la base de datos esperado
    , I get that error message, if I cut the ', the it works

    ALTER DATABASE RENAME GLOBAL_NAME TO anything;-- ok

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    whats your point? (and why bring up a 4 year old thread)

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