笔者实验多次 还是建议不要这么搞 坑很多
基本信息
mysql版本:8.0.25
查看mysql版本的方法:登录成功 mysql -h localhost -u root -p -P 3306
执行:select version();
oracle:本地mac docker下装的oracle 操作步骤
启用federated引擎
1.查看数据库引擎开启情况,默认federated为no
show engines;
2.只要在/etc/my.cnf 中添加如下配置
sudo vim /etc/my.cnf
#添加以下配置
[mysqld]
federated
3.重启mysql;
brew services restart mysql
4.然后查看federated变成了yes
远程oracle数据库建表
CREATE TABLE "TEST"."BANK"
( "ID" NUMBER(*,0),
"BANK_NAME" VARCHAR2(100)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "TEST_DATA" ;
本地mysql数据库连接
CREATE SERVER OracleTest
FOREIGN DATA WRAPPER mysql
OPTIONS (USER 'TEST', PASSWORD 'TEST',HOST 'localhost', PORT 1521, DATABASE 'XE');
CREATE TABLE remote_bank (
`ID` int,
`BANK_NAME` varchar(100) DEFAULT NULL
) ENGINE=FEDERATED CONNECTION='OracleTest/BANK';