Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.