独角兽企业重金招聘Python工程师标准>>>
执行以下SQL语句查找存放表空间的数据文件的路径SELECTddf.file_nameFROMDba_Data_Filesddfwhereddf.tablespace_name='TEST01'增加1000M到TEST01表空间(增加文件)ALTERTABLESPACETEST01ADDDATAFILE'/database/datafiles/datafile05.dbf'SIZE1000M;重新调整数据文件的大小(表空间GPS_TRACK_)alterdatabasedatafile'/database/app/oracle/oradata/gps_track_.dbf'resize50M--创建表空间createtablespaceTS_ADMIN_DATAloggingdatafile'/mnt/cnbook10/oradata/orcl/TS_ADMIN_DATA.dbf'size1000mextentMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTO;--创建用户createuserris_u_adminidentifiedbyzktdefaulttablespaceTS_ADMIN_DATA--赋权限grantconnecttoris_u_admin;grantdbatoris_u_admin;grantresourcetoris_u_admin;--Grant/Revokesystemprivilegesgrantcreateanymaterializedviewtoris_u_admin;grantcreateanyviewtoris_u_admin;grantcreatematerializedviewtoris_u_admin;grantdeleteanytabletoris_u_admin;grantdropanyclustertoris_u_admin;grantinsertanytabletoris_u_admin;grantselectanytabletoris_u_admin;grantunlimitedtablespacetoris_u_admin;grantupdateanytabletoris_u_admin;
