col OWNER for a15
col DB_LINK for a25
col USERNAME for a15
col HOST for a25
set linesize 120
select OWNER,DB_LINK,USERNAME,HOST from dba_db_links where DB_LINK in ('DB_LINK_NAME')
1.Once, the password has been given by client, then use the following statement to recreate the DBLINK,
create database link "DB_LINK_NAME" connect to TARGET_USER IDENTIFIED BY TARGET_PASS using 'TARGET_SID';
2. Verify whether DB Link is working by using the following statement,
select * from dual@DB_LINK_NAME;
3.It should return 1 row. "
Autoconfig post 12C upgrade from 11g failed with "ORA-01804: failure to initialize timezone information"
Autoconfig post 12C upgrade from 11g failed with "ORA-01804: failure to initialize timezone information" Error DB Autoconfig ...
How to drop and recreate TEMP Tablespace in Oracle 9i/10g/11g 1. Create Temporary Tablespace Temp CREATE TEMPORARY TABLESPACE TEMP2 TEMP...
How to drop and recreate UNDO Tablespace in Oracle 9i/10g/11g ? Solution : 1. Determine the size of your undo tablespace SQL> selec...
Error: " An error occurred while attempting to establish an Applications File Server connection. There may be a network configuration...