Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

My process of getting data from a remote oracle view

2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Three oracle objects are involved here, one is the customer's view, one is the oracle on the transfer station server provided by the customer, and the other is the oracle of our own development machine. Finally, we develop and use the oracle data of our own development machine for development. After the development is completed, we change the oracle source to the customer's view source, and deploy the product to the transfer station provided by the customer. And the oracle of the transit station is no longer needed and can be stopped. In fact, the web product is deployed on another node, which provides a place for computing processors to live. The following describes the specific steps for me to access the development data. I import and export in the form of a table, and the data pump of oracle is used.

Verify whether the connection is possible, assuming that the user password is xsc, the remote ip is 192.168.2.2, the instance port is 9010, and the instance name is orcltyg

Scan instance port: nmap remote ip

Sqlplus "xsc" / "xsc" @ 192.168.2.2:9010/orcltyg

Install oracle11g silently on this machine (brief)

Create tablespaces and oracle users locally. Assume that the user is xsc, and the data tablespace is xsc,temp tablespace xsctemp.

Create temporary tablespace xsctemp tempfile'/ opt/oracle/oradata/orcl/xsctemp.dbf' size 1000m autoextend on next 1000m maxsize unlimited extent management local

Create tablespace xsc logging datafile'/ opt/oracle/oradata/orcl/xsc.dbf' size 1000m autoextend on next 1000m maxsize unlimited extent management local autoallocate segment space management auto

Create user xsc identified by xsc default tablespace xsc temporary tablespace xsctemp

Grant connect,resource,dba to xsc

Create a dblink to the remote 192.168.2.2

Create database link orcltyglink connect to xsc identified by "xsc" using'(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.2.2) (PORT = 9010)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCLTYG)'

Select * from xsjl@orcltyglink

Use dblink to connect remote view to select data to create a local table xsjl

Create table xsjl as select * from xsjl@orcltyglink

Select a row to look at

Select * from xsjl where rownum

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report