FPSINPUT.BLD_DATABASE_LINK

>

> FPSINPUT.WIP_WAFER_HIST_LOOP

View FPSADMIN.BLD_DATABASE_LINK

The syntax to create a database link is difficult to remember so we store it here so we do not have to search the internet every time we need to create a link. Here is an example of the syntax: create database link yourdblink connect to fpsxxx identified by "PASSWORD" using '(DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=server.host.com) (PORT=1521)) (CONNECT_DATA=(SID=FPSDWH)))'; To build the statement above based on DBA_DB_LINKS then use this: select 'create database link ' || db_link || ' connect to ' || username || ' identified by "PASSWORD" using ''' || host || ''';' from dba_db_links; Finally, creating a link for the database to point to itself can be useful. One common case is when you have three FPS databases and one of them is the single original source of specific client information. Let's say P1 is the source and D and P2 are the others. On D and P2 you create a link with the normal syntax above but on P1 you create a link of the same name with this syntax pointing to itself. Then you can reference the same link name in views and they will work on all three databases. Syntax is like this: create database link yourdblink connect to fpsxxx identified by "PASSWORD" using 'localhost/FPSDWH';