Αποτελέσματα Αναζήτησης
4 ημέρες πριν · CLOB column over DB Link Hi Tom,We have a query which has to get a set of rows over the db link which has a CONTAINS predicate on a column of CLOB.E.g.There is a DB A and DB B with table T1( c1 varchar2(10),c2 clob) .I want to run a query from DB A using dblink on DB B to query T1 which has a CONTAINS pred
18 Μαρ 2010 · SELECT DBMS_METADATA.GET_DDL(object_type, object_name, owner) FROM all_OBJECTS WHERE (OWNER = 'your schema name'); and then search in the result the pattern of the db_link, which looks like @dblink_name.
23 Φεβ 2023 · 1) Read the database link tables to see if it is a dblink if so make a connection using that FALSE 2) Look at the order of the sqlnet.ora file to see where it is picking it's tnsname aliases from. In this case the format is TNSNAMES,ONAMES 3) Read tnsnames.ora to find out where MYDB is TRUE
17 Φεβ 2007 · I have five questions regarding the open_links parameter. 1) What resources (eg. memory, processes, etc) does each open_link use/require ? For instance, what resources are used when we have open_links = 100 ? 2) How can we monitor the number of active open_links (v$view?) ?
After you have created a database link, you can use it in SQL statements to refer to tables, views, and PL/SQL objects in the other database by appending @dblink to the table, view, or PL/SQL object name. You can query a table or view in the other database with the SELECT statement.
A database link allows a user or program to access database objects such as tables and views from another database. Once you create a database link, you can access the tables or views from the remote database using the following pattern: table_name@database_link Code language: SQL (Structured Query Language) (sql)
13 Ιαν 2011 · Database Links and LOBs Tom: I have two dbs running 8.1.6. I created a DB link from one DB to other and when I tried to do a select on a table where I have CLOB data and it's giving me error. How do I remotely copy the lob data from one db to the other?-Thx-Reji
