首页
学习
活动
专区
工具
TVP
发布
精选内容/技术社群/优惠产品,尽在小程序
立即前往
  • 您找到你想要的搜索结果了吗?
    是的
    没有找到

    oracle创建数据库命令「建议收藏」

    2. 创建表空间 CREATE TABLESPACE DATA DATAFILE ‘D:\oracle\DATA\DATA.ORA’ size 10G autoextend on next 1M Maxsize unlimited logging extent management local segment space management auto; 3.创建临时空间 CREATE TEMPORARY TABLESPACE DATA_TEMP TEMPFILE ‘D:\oracle\DATA\DATA_TEMP.ORA’ size 1G EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M; 4.创建用户并授权 CREATE USER ceshi IDENTIFIED BY ceshi DEFAULT TABLESPACE DATA TEMPORARY TABLESPACE DATA_TEMP; ALTER USER ceshi ACCOUNT UNLOCK; GRANT DBA TO ceshi; GRANT CONNECT TO ceshi; grant create any sequence to ceshi; grant drop any sequence to ceshi; grant select any sequence to ceshi; 5.用户解锁 及修改密码 conn /as sysdba; alter user ceshi account unlock; alter user ceshi identified by password;

    02
    领券