´ÓÍ·µ½Î²£¬ÉùÒô¾ÍÏñÈ˹¤»úÆ÷ÈË¡£[ѧÕß]

Ìýµ½ÏÖÔÚÓÐÖÖ´óѧʱÉϿεĸоõ¡£ÌýµÄ¶®

create user xxx identified by xxx default tablespace xxxtablespace temporary xxxtemptablespace;
grant connect to xxx;
conn xxx/xxx;
alter user xxx identified by xxxx;
alter user xxx account lock;
alter user xxx account unlock;
drop user xxx cascade;
grantµÄʱºòҪдconnect ²»ÄÜдconn
Õâ½Ú¿Î¾ÍÕâôµã¶«Î÷

лл´ó¼Ò¸øÓèµÄÖ§³Ö£¡

ʵ¼ùÏÂÈý´Î£¬È·¶¨ÁËcascade²»»á½«Óû§Á¬Í¬Æä´´½¨µÄ¶«Î÷Ò»Æðɾ³ý

select file_name from dba_data_files where tablespace_name = 'TEST1_TABLESPACE';ÕâÖÖÐÎʽÊǹ̶¨µÄÂð