oracle之导入sql（大文件）-白红宇的个人博客

oracle之导入sql（大文件）

发布日期：2021-04-30 21:06:14 浏览次数：96 分类：精选文章

本文共 2624 字，大约阅读时间需要 8 分钟。

????????Oracle????????????MySQL?????????????????????????????????????????150MB?158465??????????????

??Oracle SQL Developer?????????

???????????????SQL?????????????????????????????

??????????????SQL???????SQL Developer?????????**?????????**??????????

SQL Developer????SQL?????????????????OutOfMemory ??JVM??????????

???????

java.io.IOException: exception loading H:\oracle_image\sql.sql
    at oracle.ide.model.TextNode.openImpl(TextNode.java:549)
    at oracle.ide.model.Node.open(Node.java:1045)
    at oracle.ide.model.Node.open(Node.java:992)
    at oracle.ide.model.Node.ensureOpen(Node.java:2417)
    at oracle.ide.model.TextNode.acquireTextBuffer(TextNode.java:767)
    at oracle.jdevimpl.history.HistoryViewer.setContext(HistoryViewer.java:972)
    at com.oracle.jdeveloper.nbwindowsystem.editor.EditorState.createEditor(EditorState.java:169)
    at com.oracle.jdeveloper.nbwindowsystem.editor.EditorState.getOrCreateEditor(EditorState.java:103)
    at com.oracle.jdeveloper.nbwindowsystem.editor.SplitPaneState.canSetEditorStatePos(SplitPaneState.java:257)
    at com.oracle.jdeveloper.nbwindowsystem.editor.SplitPaneState.setCurrentEditorStatePos(SplitPaneState.java:220)
    at com.oracle.jdeveloper.nbwindowsystem.editor.TabGroupState.createSplitPaneState(TabGroupState.java:110)
    at com.oracle.jdeveloper.nbwindowsystem.editor.TabGroup.addTabGroupState(TabGroup.java:116)
    at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.createEditor(NbEditorManager.java:546)
    at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.createEditor(NbEditorManager.java:523)
    at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.openEditor(NbEditorManager.java:391)
    at oracle.ide.cmd.OpenCommand.openWithNoProject(OpenCommand.java:337)
    at oracle.ide.cmd.OpenCommand.access$100(OpenCommand.java:62)
    at oracle.ide.cmd.OpenCommand$1.run(OpenCommand.java:266)
    at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
    at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
    at java.awt.EventQueue.access$500(EventQueue.java:97)
    at java.awt.EventQueue$3.run(EventQueue.java:709)
    at java.awt.EventQueue$3.run(EventQueue.java:703)
    at java.security.AccessController.doPrivileged(Native Method)

?????

???????????????????????????????Oracle?????????????????????

?Windows?????cmd????Linux??????????????????????????Oracle???????????????????Windows XP???????

?????sqlplus ???/??@ip:??/????????????????????sqlplus system/123456@192.168.6.131:1521/oraclelates

??????????????

SQL> @E:\sql.sql;

??????@???/sql?????SQL????????????commit???

???????????????????????????????????

上一篇：javaWEB基础(servlet4)

下一篇：关于购物网站的设计概念

发表评论

关于作者

喝酒易醉，品茶养心，人生如梦，品茶悟道，何以解忧？唯有杜康！

-- 愿君每日到此一游！

发表评论

最新留言

关于作者

推荐文章