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
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';
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?
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.
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
whats your point? (and why bring up a 4 year old thread)
Click Here to Expand Forum to Full Width