我的AWS ec2实例中有oracle转储文件,我想将此转储文件导入AWS RDS中的Oracle数据库.
I have oracle dump file in my AWS ec2 instance, I want to import this dump file to Oracle database in AWS RDS.
我尝试与Oracle SQL Developer以及Perl脚本一起使用.
I tried using with Oracle SQL developer and also using Perl script.
docs.aws.amazon /AmazonRDS/latest/UserGuide/Oracle.Procedural.Importing.html
如何导入oracle转储从ec2实例到AWS中的RDS
使用Oracle SQL Developer方法,未启用数据库复制"选项. 使用Perl,在运行脚本时会出现很多错误.
Using Oracle SQL Developer method, the 'Database Copy' option is not enabled. Using Perl, getting a lot of error while running the script.
[root@ip-172-28-1-70 oracle]# perl dump_exp.pl install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at (eval 4) line 3. Perhaps the DBD::Oracle perl module hasn't been fully installed, or perhaps the capitalisation of 'Oracle' isn't right. Available drivers: DBM, ExampleP, File, Gofer, Mem, Proxy, SQLite, Sponge. at dump_exp.pl line 23.这两种方法都不适合我,并且不了解Perl.
this both methods are not working for me, and am not aware of Perl.
请告诉我是否有更好的方法.
Please suggest me if have any better method.
推荐答案AWS RDS不允许目录访问.
AWS RDS does not allow directory access.
如果可以使用原始导出exp进行导出, 您可以使用oracle客户端和原始导入实用程序imp从任何工作站导入.
If you can export using the original export exp, you can import from any workstation with oracle client and the original import utility imp.
更多推荐
如何将oracle转储文件上传到oracle数据库:AWS RDS
发布评论