drop db link

DB link migration (the password in dblink is unknown), dbdblinkI don't know if DBAs sometimes encounter such a situation where the Public db link is used for Schema migration. However, the target account password in db link is unknown, therefore,

I do not know whether the DBA will sometimes encounter such a embarrassed embarrassed situation, to do some schema migration, due to the use of the public DB link, however, because do not know the DB link target account password, it is not possible

 How to create an oracle db Link   Known: database 1: test1; database 2: Test2Requirement: Create a DB link from database 1 to database 2 Solution 1: 1. on the computer where database 1 is located, create the service name to database 2:

1.autoCommit (), commit (), rollback ()function autocommit ($onoff =false)Specifies whether the transaction is committed automatically. Some back-end databases are not supported.function commit ()Commit the current transactionfunction rollback

Links between databases are built on database link. To create a DB link, you must first set up the link string on each database server. 1, configure TNS, $ORACLE _home/network/admin/tnsname.ora 10gstandby = (DESCRIPTION = (address = (PROTOCOL =

The links between databases are established on the database link. To create a DB link, you must first set the link string on each database server. 1. Configure TNS, $ ORACLE_HOME/Network/admin/tnsname. ora 10 gstandby = (Description = (Address =

The Administrator cannot delete the DB Link created by other users (for example, emcd ): (1) you can log on to the database as an administrator, query dba_users, and write down the values of the user's emcd password: SQL> select username, password

Source database:Computer Name: bkjiaDatabase Name: orcl Target database:Computer Name: suzhouDatabase Name: ocp 0. Create a test table for the target databaseSQL> conn scott/passwordConnected.SQL> show user;The USER is SCOTT"SQL> create table t12 (3

? Describe the DBA's responsibility for security and audit work? Enable standard database auditing? Specify audit options? Review audit information? Maintain audit trail Segregation of duties ? A user with DBA authority must be

First, synonym synonymConnect sys/123 as SYSDBA;SELECT * from EMP;ORA-00942: Table or view does not existCreate synonym emp for scott.emp;SELECT * from EMP;1. DefinitionA synonym is an alias for a pattern object.Can be a table or view, sequence,