如何在Oracle SQL Developer工具中运行.sql文件以导入数据库? [英] How to run .sql file in Oracle SQL developer tool to import database?

问题描述

我已将数据库从Oracle SQL开发人员工具导出到.sql文件.现在，我要运行大小超过500 MB的文件.

I have exported database from Oracle SQL developer tool into .sql file. Now I want to run this file which is of size 500+ MB.

我在此处中了解了运行脚本，但我不明白这条路.是否有任何命令或查询可通过提供路径来运行此sql脚本?

I read about running scripts here, but I didn't understand the way. Is there any command or query by which we can run this sql script by providing path?

推荐答案

您可以在 SQL Developer 工作表中将.sql文件作为脚本执行.使用运行脚本图标，或直接按 F5 .

You could execute the .sql file as a script in the SQL Developer worksheet. Either use the Run Script icon, or simply press F5.

例如，

@path\script.sql;

请记住，您需要如上所述放置@.

Remember, you need to put @ as shown above.

但是，如果使用SQL Developer的数据库导出实用程序导出了数据库，则应该使用Import实用程序.请遵循此处提到的步骤使用Oracle SQL Developer 3.0导入和导出

But, if you have exported the database using database export utility of SQL Developer, then you should use the Import utility. Follow the steps mentioned here Importing and Exporting using the Oracle SQL Developer 3.0

这篇关于如何在Oracle SQL Developer工具中运行.sql文件以导入数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！