With PL/SQL Developer 6.0.5, I export a table that is defined with the CACHE clause using the SQL Inserts tab, but when I Import it, the create table statement has an error because of a blank line before cache.
prompt PL/SQL Developer import file
prompt Created on Monday, June 27, 2005 by rstrand
set feedback off
set define off
prompt Creating RFJA_TYPE_OF_REQUEST_LOV...
create table RFJA_TYPE_OF_REQUEST_LOV
(
TYPE_OF_REQUEST VARCHAR2(2) not null,
TYPE_OF_REQUEST_DESCRIPTION VARCHAR2(45) not null
)
cache;
If the blank line is removed, the statement works.
prompt PL/SQL Developer import file
prompt Created on Monday, June 27, 2005 by rstrand
set feedback off
set define off
prompt Creating RFJA_TYPE_OF_REQUEST_LOV...
create table RFJA_TYPE_OF_REQUEST_LOV
(
TYPE_OF_REQUEST VARCHAR2(2) not null,
TYPE_OF_REQUEST_DESCRIPTION VARCHAR2(45) not null
)
cache;
If the blank line is removed, the statement works.