Oracle creates tablespaces
Drop tablespace qb including contents and datafiles;DROP TABLESPACE TJLGL INCLUDING CONTENTS AND DATAFILES;drop user qb cascadecreate tablespace qb loggingdatafile'E:\ app\ landa6\ oradata\ qb.DBF'-- (tablespace path) size 32m autoextend on next 32m extent management local; create user qb identified by qb default tablespace qb grant dba to qb;-- (assign permissions to users) SELECT 'DELETE FROM' | | table_name |'; 'FROM USER_TABLES ORDER BY TABLE_NAME
