tora
tora copied to clipboard
storage manager: cannot create tablespace
when it's configured in UI dialog:
Thu Apr 21 13:49:09 2016
trotl_stat.cpp:512 bool trotl::SqlStatement::execute_internal(ub4, ub4)
ORA-01741: illegal zero-length identifier
error at SQL position 18 [1.19]:
CREATE TABLESPACE "" DATAFILE '' SIZE 1048576 K REUSE AUTOEXTEND OFF MINIMUM EXTENT 1048576 K LOGGING ONLINE PERMANENT EXTENT MANAGEMENT DICTIONARY
^
last SQL statement:
CREATE TABLESPACE "" DATAFILE '' SIZE 1048576 K REUSE AUTOEXTEND OFF MINIMUM EXTENT 1048576 K LOGGING ONLINE PERMANENT EXTENT MANAGEMENT DICTIONARY
0x7fba4776f10e: trotl::OciException::OciException(std::string, trotl::SqlStatement&) in /home/pvanek/oss/tora/release/lib64/libtrotl.so
0x7fba4776999b: trotl::SqlStatement::execute_internal(unsigned int, unsigned int) in /home/pvanek/oss/tora/release/lib64/libtrotl.so
0x7fba4776f59a: trotl::SqlStatement::pre_read_value() in /home/pvanek/oss/tora/release/lib64/libtrotl.so
0x7fba477691c4: trotl::SqlStatement::eof() in /home/pvanek/oss/tora/release/lib64/libtrotl.so
0x7fba472165a1: oracleQuery::eof() in /home/pvanek/oss/tora/release/lib64/tora-3.0/libporacle.so
0xa16099: toQueryAbstr::eof() in ./bin/tora
0x9e771d: toConnectionSubLoan::execute(QString const&) in ./bin/tora
0xed6090: toStorage::newTablespace() in ./bin/tora
0x9ad9f6: uknown symbol in ./bin/tora
0x7fba6c2fccc6: QMetaObject::activate(QObject*, int, int, void**) in /usr/lib64/libQt5Core.so.5
but the statement is correct when I click "preview sql"
CREATE TABLESPACE "OMQ_DATA" DATAFILE '/u01/app/oracle/oradata/orcl/omq_data.dbf' SIZE 1024 K REUSE AUTOEXTEND ON NEXT 1024 K MAXSIZE 1024 K MINIMUM EXTENT 1024 K LOGGING ONLINE PERMANENT EXTENT MANAGEMENT DICTIONARY;