oracle select from another database without dblink

CREATE Database Link Test_dblinkCONNECT to SJZX identified by SJZXUSING ' (DESCRIPTION =(Address_list =(ADDRESS = (PROTOCOL = TCP) (HOST = 10.176.150.201) (PORT = 1521)))(Connect_data =(service_name = ORCL)))‘;Database Link OverviewDatabase link is

Oracle Create, delete database LINKCreate Dblink: Create database link [name] connect to [username] identified by [password] using ' (DESCRIPTION = (address_ LIST = (address = (PROTOCOL = TCP) (HOST = [IP]) (port = [port]))

Common exceptions:ORA-14025: Cannot specify partition for a solid view or a solid view logOra-14026:partition and cluster clauses repel each otherORA-14027: Only one partition clause can be specifiedORA-14028: Missing at or values

Find Dblink If very slow can add a/*+driving_site (XXX) in this way */, query quicklyDBLINK HINT/*+ driving_site (org) */optimization strategy and ideasOptimization strategies and ideas for using the Dblink remote Access database:Strategy: Remote

Access Remote Using select statements locally, if the remote table has a CLOB field, it will be wrong: ora-22992;If you really want to see the content of the clob field, you have to create a table locally and use the following two statements:I just

1 Introduction Oracle Official network: http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10727/strmover.htm Oracle Stream functionality is designed to improve the high availability of the database, which is known as Advance Replication

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,

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,

Article Summary: Oracle is a database platform, and some projects use Oracle's database replication technology, which also encounters some problems, so here I have a personal understanding of Oracle's replication technology, hoping to help the

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