ME_505734971的博客

添加新节点用功能、菜单注册相关数据库表 功能、菜单注册相关数据库表 –菜单实体 select * from sm_menuitemreg order by ts desc; –菜单项注册实体 sm_menuregister select * from sm_menuregister order by ts desc; –模块信息 (dap_dapsystem) select * from dap...

创建表空间、用户、授权、扩展表空间 CREATE TABLESPACE NNC_DATA02 DATAFILE ‘F:\ORADATA\nnc_data02.dbf’ SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ; CREATE TABLESPACE NNC_INDEX02 DATAFILE ...

删除数据库用户以及表空间 –查找用户 select *　from dba_users; –查找工作空间的路径 select * from dba_data_files; –删除用户 drop user nc65 cascade; –删除表空间 drop tablespace NNC_INDEX01 including contents and datafiles cascade constrai...