Shulou(Shulou.com)06/01 Report--

Editor to share with you about oracle12 to create user-specified tablespaces, I believe that most people do not know much, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

-1. Create a temporary space create temporary tablespace zyj_temptempfile 'd:\ app2\ user\ virtual\ oradata\ orcl\ zyj_temp.dbf'size 50mautoextend onnext 50m maxsize 20480mextent management local;--2. Create the data tablespace create tablespace zyj_dataloggingdatafile 'D:\ app2\ user\ virtual\ oradata\ orcl\ zyj_data.dbf'size 50mautoextend onnext 50m maxsize 20480mextent management local;--3. Create a user and specify the tablespace-at the beginning, the user name is zyj, indicating an error ORA-65096: the public user name or role name is invalid. Look up the information on the Internet, saying that the prefix for the name must be clocked, so the user name is also changed to cymbal zyj_data. When you create a user for the first time, you will be prompted that the tablespace does not exist, restart the service and create a successful create user c##zyj identified by 1234default tablespace zyj_datatemporary tablespace zyj_temp;--4. Authorization to cantileverzyjMagery PS: set permissions GRANT CREATE ANY VIEW,DROP ANY VIEW,CONNECT,RESOURCE,CREATE SESSION,DBA TO cymbzyjaster as needed-delete users and tablespaces drop user c##zyj cascade;DROP TABLESPACE zyj_data INCLUDING CONTENTS AND DATAFILES;-- delete empty tablespaces, but do not contain physical files drop tablespace tablespace_name;-- delete non-empty tablespaces, but do not include physical files drop tablespace tablespace_name including contents Delete empty tablespaces, including physical files drop tablespace tablespace_name including datafiles;-- delete non-empty tablespaces, include physical files drop tablespace tablespace_name including contents and datafiles;-- if the tables in other tablespaces have foreign keys and other constraints associated with the fields of tables in this tablespace, add CASCADE CONSTRAINTSdrop tablespace tablespace_name including contents and datafiles CASCADE CONSTRAINTS;select tablespace_name from DBA_tablespaces The above is all the content of the article "oracle12's method of creating user-specified tablespaces". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.