美文网首页
Oracle DDL语句

Oracle DDL语句

作者: vubh | 来源:发表于2017-04-25 09:36 被阅读0次
    1. 创建表空间
    create tablespace wbh  
    logging  
    datafile 'C:\oraclexe\app\oracle\oradata\XE\wbh.dbf'
    size 500m  
    autoextend on  
    next 500m maxsize 20480m  
    extent management local; 
    
    1. 删除表空间
    DROP TABLESPACE wbh INCLUDING CONTENTS AND DATAFILES;
    
    1. 创建表空间下用户
    create user wbh identified by wbh
    default tablespace wbh;
    
    1. 授权
    grant connect,resource,dba to wbh
    

    相关文章

      网友评论

          本文标题:Oracle DDL语句

          本文链接:https://www.haomeiwen.com/subject/buouzttx.html