Error in using bind variables in tablespace creation script

[kamal_k_joshi]

Try something like this:

SQL> column file_name new_value tsp
SQL>
SQL> SELECT SUBSTR(NAME,1,INSTR(NAME,'\',-1)) ||'DEMODATA01.DBF' file_name
2 FROM V$DATAFILE
3 WHERE ROWNUM < 2;

FILE_NAME
------------------------------------------------------------------------------------------------------------------------------
E:\ORACLE\ORADATA\KKISHORE\DEMODATA01.DBF

1 row selected.

SQL>
SQL> CREATE TABLESPACE DEMODATA DATAFILE '&tsp' SIZE 2048 M EXTENT MANAGEMENT LOCAL;
old 1: CREATE TABLESPACE DEMODATA DATAFILE '&tsp' SIZE 2048 M EXTENT MANAGEMENT LOCAL
new 1: CREATE TABLESPACE DEMODATA DATAFILE 'E:\ORACLE\ORADATA\KKISHORE\DEMODATA01.DBF' SIZE 2048 M EXTENT MANAGEMENT LOCAL

Tablespace created.

SQL>