Monday, August 1, 2022
How to drop other schema’s Database link using SYS user | Drop db_link from other user
SQL> select owner,db_link from dba_db_links;
OWNER DB_LINK
------------------------------ --------------------------------------
TEST TEST_DB_LINK
SQL> sho user
USER is "SYS"
SQL>
SQL> drop database link test.test_db_link;
drop database link test.test_db_link
*
ERROR at line 1:
ORA-02024: database link not found
[test@test.test.com ~]$ cat drop_schema_dblink.sh
username=$1
db_link=$2
sqlplus /nolog < SQL> Connected.
SQL> " DB Link Before Drop"
SQL> SQL> SQL>
OWNER DB_LINK
------------------------------ ------------------------------
TEST TEST_DB_LINK
SQL> 2 3 4 5
Procedure created.
SQL>
PL/SQL procedure successfully completed.
SQL>
Procedure dropped.
SQL> " DB Link After Drop"
SQL>
no rows selected
SQL>
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
!
Subscribe to:
Post Comments (Atom)
Real estate builders fraud
actual carpet area 1000sft and common area 30% it should be 1300 but builder sell it as 1430 sft saying 30% common area. where as they a...
-
adcfgclone.pl Different Components There are different components with Rapid Clone that are used when cloning an Oracle Applications inst...
-
Creating an ACFS file system on OCI DB system In an DB system on OCI if we want to add any file system then we can use the ACFS file syste...
-
10 References This section lists the reference material that can be read to gain further knowledge in the various areas relevant to establi...
No comments:
Post a Comment