开启Oracle的帮助系统--不再害怕忘记命令的尴尬(二)
create a database link. A database link is a
schema object in the local database that allows you to access
objects on a remote database or to mount a secondary database in
read-only mode. The remote database can be either an
Oracle or a
non-Oracle system.
CREATE [PUBLIC] DATABASE LINK dblink
[CONNECT TO user IDENTIFIED BY password]
[USING 'connect_string']
For detailed information on this command, see the Oracle8 Server SQL
Reference.
太好了吧。这样再也不用担心忘记命令了,不过,作为一个熟练的DBA人员,记住大部分的命令,而且熟练的在客户面前敲出来,能获得更好的赞赏哟。所以这个工具是一个以备不时不需的作用,而不要成为你偷懒的工具了哟。