Database Link of IT Ninja Turtles: database of Ninja Turtles

Database Link of IT Ninja Turtles: database of Ninja Turtles

-CREATE public database link test_link connect to scott identified by tiger using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = LEE) '; -- use select ename from emp @ test_link; -- delete drop public database link TEST_LINK;

 

 

I. dblink creation:

 

 

 

 

 

1. Local services have been configured

Create public database

Link toBeJing connect to scott
Identified by tiger using 'bejing'

 

The database connection string 'bejing' is the alias name defined in the TNSNAMES. ORA file of the current client database. You can use NET8 easy config or directly modify the definition in TNSNAMES. ORA.

 

2. directly create a link

Create database link toBeJing

Connect to scott identified by tiger
Using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = X. X) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = BJORCL)
)
)';

Create database link toIAS
Zookeeper authentication connect to ias identified by cis
Required bytes have been using '(DESCRIPTION =
¡(ADDRESS_LIST =
Zookeeper PROTOCOL (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521 ))
Too many threads ¡¡¡¡)
¡(CONNECT_DATA =
Required bytes have been created (SERVICE_NAME = cis1.com)
Too many threads ¡¡¡¡)
¡¡¡¡)';

Host = IP address of the database, service_name = ssid of the database.

In fact, the two methods are similar in dblink configuration. I personally feel that the second method is better, so it is not affected by the local service.

Note: If you create a global dblink, you must use the mongom or sys user and add public before the database.

1. Create a public database link without specifying the user and password.

Scott @ TEST> conn system/test
Connected.
System @ TEST> create public database link orcl USING 'bejing ';
Database link created.

2. Create a private database link under each user (with the same name as the public database link) and specify the user and password.
System @ TEST> conn scott/tiger
Connected.
Scott @ TEST> create database link orcl connect to scott identified by tiger;
Database link created.

Actually equivalent:

Create database link orcl USING 'bejing' connect to scott identified by tiger;

 

Db link has three types: connected user and fixed user.
In short, the connected database uses the connected user to connect to the remote database.
Fixed user. In short, the database of the connected party uses the fixed (specified) user to connect to the remote database.

 

Let's take a look at the db link creation syntax. You can see the two types clearly.

The db link syntax for creating a connected user is as follows:
Create databas link foo connect to scott identified by tiger using 'bejing ';

Db link syntax for creating fixed user:
Create databas link foo using 'bejing ';

 

The name of the db link is related to global_names. global_name is the global name of the database, and global_name must be unique in the database you manage. The database name is db_name. Generally, database names are short. In my habit, the length is generally 4 characters, and the probability of duplicate names is high.

Therefore, oracle imitates the domain name to create a global_name, global_name = db_name + db_domain.
With global_name, the database name can be globally unique. Example: ORCL. REGRESS. RDBMS. DEV. US. ORACLE. COM

 

You can use the following command to check the global name of the database:
SELECT * FROM GLOBAL_NAME;

 

If global_names = true, the db link name must be the same as the global_name of the remote database;
If global_names = false, you can name db link as needed.

 

Query whether global_names is true or false. Execute show parameter global_names in the Command window (not the SQL window) of pl/SQL.

 

2. dblink query:

View All database links, go to the system administrator SQL> operator, and run the following command:
SQL> select owner, object_name from dba_objects where object_type = 'database link ';

 

Iii. dblink deletion:

Drop public database link toBeJing

 

4. dblink usage:

SELECT ...... FROM table name @ Database Link name;

Querying, deleting, and inserting data are the same as operating a local database, except that the table name must be written as "table name @ dblink server.

For example, select * from emp @ toBeJing;

 

5. synonym combination:

In the fourth point, from emp @ toBeJing can be used to create Synonyms:
Create synonym name FOR table name;

Create synonym name FOR table name @ Database Link name;

For example, create synonym bj_scott_emp for emp @ toBeJing;

So we can use bj_scott_emp to replace the Distributed Link operation with the @ symbol emp @ toBeJing.

 

Db link is independent of the USERNAME used to create a user (USER_DB_LINKS USERNAME). Other users cannot use this connection or delete it without permission.

 

What is the name of the Ninja Turtles 2012 theme song?

Ninja Turtles! Teenage Mutant Ninja Turtles!
Turtles count it off!
One, Two, Three, Four!
(Turtles !) Mutant chain reaction.
(Turtles !) Service' underground.
(Turtles !) Ninjitsu action.
(Turtles !) It's a shell of a town!
Turtles count it off!
(One !) Live by the code of the martial arts.
(Two !) Never fight unless someone else starts.
(Three !) Always stick together no matter what.
(Four !) If all else fails then it's time to kick butt!
I love bein '(I love bein ')
I love bein '(I love bein ')
I love being a Turtle!
Teenage Mutant Ninja Turtles!
Turtles count it off!
One, Two, Three, Four!
(Turtles !) There's no one better.
(Turtles !) "Watch out for Shredder! "
(Turtles !) They're like no others.
(Turtles !) Those teenage brothers.
One, Two, Three, Four!
One, Two, Three, Four!
Teenage Mutant Ninja Turtles!
 
If afc2 is installed in itouch jailbreak, the connection number wifi is restarted. As a result, when cydia is opened, error: database appears,

Version 3.1.3 is too old ...... Many plug-ins may conflict with the old version of the apple host. I suggest you upgrade to the latest version 5.1.1 (flash machine upgrade), and the perfect jailbreak will soon appear (the unperfect jailbreak has already come out). Please upgrade it.