Running Oracle 9.2.0.1.0
I created 2 tablespaces with corresponding datafiles with this script:
-------------------------------------------
ORACLE_HOME='/opt/oracle/product/9.2/' ; export ORACLE_HOME
ORACLE_SID=TESTDB ; export ORACLE_SID
NLS_LANG=swedish_sweden.we8iso8859p1; export NLS_LANG

$ORACLE_HOME/bin/sqlplus system/manager@TESTDB< CREATE TABLESPACE "system_tbs" LOGGING DATAFILE '/local/db/oracle/oradata/SYSTEM_DATA.dbf' SIZE 600M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEM
ENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
exit;
EOF

$ORACLE_HOME/bin/sqlplus system/manager@TESTDB< CREATE TEMPORARY TABLESPACE "system_temp" TEMPFILE '/local/db/oracle/oradata/SYSTEM_TEMP.dbf' SIZE 300M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAG
EMENT LOCAL UNIFORM SIZE 1M;
exit;
EOF
-------------------------------------------
The datafiles are created BUT when I try to create my user:
-------------------------------------------
$ORACLE_HOME/bin/sqlplus system/manager@TESTDB< drop user myuser cascade;
create user myuser identified by mypassword
default tablespace system_tbs
quota unlimited on system_tbs;
exit;
EOF
-------------------------------------------

I got an error message telling me that system_tbs does not exist!!

I can't DROP the tablespace either because it does not exist!..

..still it shows up in v$tablespace!!

Why?