您好,登錄后才能下訂單哦!
這里涉及到三個(gè)oracle對(duì)象,一個(gè)是客戶的視圖,一個(gè)是客戶提供的中轉(zhuǎn)站服務(wù)器上的oracle,一個(gè)是我們自己的開發(fā)機(jī)的oracle,最終我們開發(fā)使用自己開發(fā)機(jī)的oracle的數(shù)據(jù)來進(jìn)行開發(fā),開發(fā)完成后,將oracle源改為客戶的視圖源,將產(chǎn)品部署到客戶提供的中轉(zhuǎn)站上。并且中轉(zhuǎn)站的oracle也已經(jīng)不再需要,可以停掉,實(shí)際上web產(chǎn)品部署在另外一個(gè)節(jié)點(diǎn),這個(gè)中轉(zhuǎn)站提供計(jì)算處理程序的居住場(chǎng)所。下面介紹我接入開發(fā)數(shù)據(jù)的具體步驟,我是按表的形式進(jìn)行導(dǎo)入導(dǎo)出,并且用到的是oracle的數(shù)據(jù)泵。
驗(yàn)證是否能夠連接,假設(shè)用戶密碼都是xsc,遠(yuǎn)端ip是192.168.2.2,實(shí)例端口9010,實(shí)例名orcltyg
掃描實(shí)例端口: nmap 遠(yuǎn)端ip
sqlplus "xsc"/"xsc"@192.168.2.2:9010/orcltyg
本機(jī)靜默安裝oracle11g(略)
本機(jī)創(chuàng)建表空間和oracle用戶,假設(shè)用戶為xsc,數(shù)據(jù)表空間為xsc,temp表空間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;
創(chuàng)建到遠(yuǎn)端192.168.2.2的dblink
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;
通過dblink連接遠(yuǎn)端視圖選取數(shù)據(jù)創(chuàng)建本地的表xsjl
create table xsjl as select * from xsjl@orcltyglink;
選取一行來看
select * from xsjl where rownum<=1;
把它備份出來,并用ftp工具下載
mkdir /backup
chown -R oracle.oinstall /backup/
sqlplus / as sysdba
create or replace directory dir as '/backup/';
grant write,read on directory dir to xsc;
quit
nohup expdp xsc/xsc@orcl tables=xsjl dumpfile=xsjl.dmp logfile=xsjl.log directory=dir job_name=xsjl_job &
通過ftp或者sz下載,然后上傳到開發(fā)的oracle主機(jī)上
還原到開發(fā)機(jī)的oracle中
sqlplus / as sysdba
create temporary tablespace xsctemp tempfile '/u01/app/oracle/oradata/consume/xsctemp.dbf' size 1000m autoextend on next 1000m maxsize unlimited extent management local;
create tablespace xsc logging datafile '/u01/app/oracle/oradata/consume/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;
quit
mkdir /u01/backup/
chown -R oracle.oinstall /u01/backup/
sqlplus / as sysdba
create or replace directory dir as '/u01/backup/';
grant write,read on directory dir to xsc;
quit
cd /u01/backup
rz [xsjl.dmp]
nohup impdp xsc/xsc dumpfile=xsjl.dmp logfile=xsjl.log directory=dir tables=xsjl job_name=xsjl_job &
驗(yàn)證
select * from xsjl where rownum<=1;
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。