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: 10.2.0.1 to 10.2.0.4 - Release: 10.2 to 10.2
Information in this document applies to any platform.

Symptoms

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>@test.sql

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.
SQL> TABLESPACE "TEST_TS",

Cause

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