Execution Of SQL File SQL*Plus Utility Causes SP2-734 SP2-44

(Doc ID 752411.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: to - Release: 10.2 to 10.2
Information in this document applies to any platform.


The SQL file test.sql is generated by the DataPump import utility with parameter SQLFILE to extract the DDLs from export dump file:

#> impdp scott/tiger dumpfile=scott.dmp log=scottimp.log directory=dir sqlfile=test.sql

In SQLFILE you find line feeds and blank lines like this:

SUBPARTITION "P_01_09_2008_SP_5841" VALUES
(5841)                                      --> line feed
SUBPARTITION "P_01_09_2008_SP_5842" VALUES(5842)
                                            --> blank line
tablespace "TEST_TS"

If you run the file test.sql in SQL*Plus, then yu receive the errors:


SQL> SUBPARTITION "P_01_09_2008_SP_5841" VALUES (5841)
SP2-0734: Unbekannter Befehl ab "SUBPARTITI..." - restliche Zeile ignoriert.
SP2-0044: Zum Auflisten bekannter Befehle HELP
und zum Verlassen EXIT eingeben.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms