Problem regarding modification of global name and with import

[dasdeba]

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

[julian]

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?

[reydp]

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.

[cachitok]

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

[davey23uk]

whats your point? (and why bring up a 4 year old thread)