Oracle 12.2 设置LOCAL_TEMP_TABLESPACE
12.2 设置LOCAL_TEMP_TABLESPACESQL>? select username,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE,LOCAL_TEMP_TABLESPACE from dba_users;USERNAME?? ??? ?? DEFAULT_TABLESPACE?? ??? ? TEMPORARY_TABLESPACE?? ??? ?LOCAL_TEMP_TABLESPACE------------------------- ------------------------------ ------------------------------ ------------------------------SYS?? ??? ??? ?? SYSTEM?? ??? ??? ? TBSB_NYTMP?? ??? ??? ?TEMPSYSTEM?? ??? ??? ?? SYSTEM?? ??? ??? ? TBSB_NYTMP?? ??? ??? ?TEMPSIBP_NY ?? ??? ?? SYSTEM?? ??? ??? ? TBSB_NYTMP?? ??? ??? ?TEMPselect ‘alter user ‘||username||‘ LOCAL TEMPORARY TABLESPACE ‘||TEMPORARY_TABLESPACE||‘;‘from dba_users where username not in (‘XS$NULL‘); ??SQL> select username,LOCAL_TEMP_TABLESPACE from dba_users;??USERNAME?? ??? ?? DEFAULT_TABLESPACE?? ??? ? TEMPORARY_TABLESPACE?? ??? ?LOCAL_TEMP_TABLESPACE------------------------- ------------------------------ ------------------------------ ------------------------------XS$NULL ?? ??? ?? SYSTEM?? ??? ??? ? TBSB_NYTMP?? ??? ??? ?TEMPSYS?? ??? ??? ?? SYSTEM?? ??? ??? ? TBSB_NYTMP?? ??? ??? ?TBSB_NYTMPSYSTEM?? ??? ??? ?? SYSTEM?? ??? ??? ? TBSB_NYTMP?? ??? ??? ?TBSB_NYTMPGSMCATUSER?? ??? ?? SYSTEM?? ??? ??? ? TBSB_NYTMP?? ??? ??? ?TBSB_NYTMP (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |