ORA-32773: operation not supported for smallfile tablespace USERS 解決
錯誤描述:
SQL> alter tablespace users resize 300m;
alter tablespace users resize 300m
*
ERROR at line 1:
ORA-32773: operation not supported for smallfile tablespace USERS
SQL> select file_id, tablespace_name from dba_data_files;
FILE_ID TABLESPACE_NAME
---------- ------------------------------
1 SYSTEM
2 UNDOTBS1
3 SYSAUX
4 USERS
SQL> alter database datafile 4 resize 300m;
Database altered.
//--------Description from online documents------------------------------------------------------------------
ORA-32773: operation not supported for smallfile tablespace string
Cause: An attempt was made to perform. an operation which is supported only for bigfile tablespaces, e.g. resize tablespace.
Action: Use the appropriate clause of the ALTER DATABASE DATAFILE command instead.
SQL> alter tablespace users autoextend off;
alter tablespace users autoextend off
*
ERROR at line 1:
ORA-32773: operation not supported for smallfile tablespace USERS
SQL> alter database datafile 4 autoextend off;
Database altered.
小錯誤也記一下,全當積累了~~~
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/31397003/viewspace-2136507/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- cuda runtime error (801) : operation not supportedError
- ORA-01552: cannot use system rollback segment for non-system tablespace 'USERS'錯誤解決
- Mac新建資料夾報錯,mkdir():Operation not supportedMac
- 解決The given version [xx] is not supported, only version 1 to 10 is supported in this buildUI
- 解決 Lumen 中 client charset is not supportedclient
- 解決Project facet Java version 1.8 is not supported.ProjectJava
- Mac OS X is not supported with software virtualization解決方法Mac
- chown: /usr/local: Operation not permitted問題解決MIT
- 使用npm install報錯-4048 operation not permitted解決NPMMIT
- Apache無法啟動解決 the requested operation has failedApacheAI
- pyhton3解決”tuple parameter unpacking is not supported”問題
- 解決報錯error the @annotation pointcut expression is only supported at Java 5ErrorExpressJava
- ORA-25153: Temporary Tablespace is Empty 解決方法
- 解決辦法:ORA-00845: MEMORY_TARGET not supported on thi
- ORA-00845: MEMORY_TARGET not supported on this system報錯解決
- ORA-00845 MEMORY_TARGET not supported on this system報錯解決
- 【轉】Oracle-Bigfile and SmallfileOracle
- Types of Oracle Database Users : Database Users (6)OracleDatabase
- CREATE TABLESPACE命令詳解
- idea 提示 string template are not supported current JavaScrip Version 的解決【筆記】IdeaJava筆記
- “ORA-00845: MEMORY_TARGET not supported on this system”不完全解決之道
- ORA-00845: MEMORY_TARGET not supported on this system 失敗的解決方案
- ORA-29702:error occurred in Cluster Group Service operation錯誤解決Error
- The operation, ‘DecodeJpeg/contents‘, does not exist in the graph.錯誤解決方法
- 解決 connect to host github.com port 22 operation timed outGithub
- PHP報錯getimagesize(): SSL operation failed with code 1問題解決方案PHPAI
- PermissionError: [Errno 13] Permission denied: 'C:\\Users\\jason\\Documents\\t2'的解決方案Error
- 解決STS或者Eclipse卡死在remote system explorer operation問題EclipseREM
- svn“Previous operation has not finished; run ‘cleanup‘ if it was interrupted“報錯的解決方法
- oracle smallfile 大小和塊大小關係Oracle
- CREATE TABLESPACE命令詳解(轉)
- 大資料解決方案(一)之表空間--bigfile tablespace大資料
- DISK OPERATION ERROR,交換機級聯單模光纖鏈路故障解決Error
- Oracle default usersOracle
- 使用pip install安裝.whl檔案出現is not a supported wheel on this platform解決辦法Platform
- npm 或 yarn安裝依賴報錯 EPERM: operation not permitted, unlink 解決方法NPMYarnMIT
- idea使用svn “Previous operation has not finished; run 'cleanup' if it was interrupted“報錯的解決方法Idea
- linux操作提示:“Can't open file for writing”或“operation not permitted”的解決辦法LinuxMIT