It is necessary in the script to request data from the user and use as the name of the schema and space for DDL. What am I doing wrong?

var :cscheme varchar(20); var :ctspace varchar(20); exec :cscheme := &CUR_SCH; exec :ctspace := &CUR_TSPACE; CREATE TABLE :cscheme."TNABE" ( "V1" NUMBER, "V2" NUMBER, "V3" CHAR(10 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE :ctspace;

Error: ORA-00903: invalid table name

  • @MaxU And what is the reason for deleting the answer? Yet it was true. - 0xdb
  • Doesn't this question interest you anymore? Maybe it was caused by a typo? - 0xdb
  • Interested, the script is working. But it incorrectly forms the name of the table. I would like to know what the error is or it is not a mistake, but features of macro substitutions. - Anatoly Ernst
  • But @MaxU gave you the answer and it was correct. You did not accept it and did not leave a comment with the remark. - 0xdb
  • I reopened the message after deleting the answer and did not see it - Anatoly Ernst

0