How to create and delete tablespaces in Oracle cainiao

How to create and delete tablespaces in Oracle cainiao

1. When creating a temporary tablespace and creating a tablespace, dbf Files are generally stored in the directory where the datafile file is stored (typically under the folder named by instance name), you can select * from v $ datafile; view the storage location of all data files. create temporary tablespace name tempfile '/data/oradata/CHUANSHU/datafile/tmp _ file name. dbf 'size 50 M autoextend on next 1 M maxsize 1024 Mextent management local; 2. create a formal tablespace create tablespace name logging datafile'/data/oradata/CHUANSHU/datafile/file name. dbf 'size 124 M autoextend on next 1 M maxsize 10240 Mextent management local; 3. create a database user create user username identified by passworddefault tablespace name temporary tablespace name; 4. Authorize the newly created database user grant dba to username; grant connect to username; grant resource to username with admin option; grant unlimited tablespace to inspur_rmw with admin option; // grant dba to username with admin option; can complete this function; 5. Delete the tablespace drop tablespace tabaspacename including contents and datafiles; // delete both the tablespace and data files

How to completely delete users and tablespaces created by oracle

If you want to delete a tablespace, you can delete the corresponding file. In this way, you can drop tablespace ocscdrbak including contents; drop tablespace tablespace_name including contents and datafiles;
Windows requires offline.

How to delete users and tablespaces created in oracle

To delete a user, you can use the drop user Username cascade. cascade is an optional parameter. With this parameter added, all schemas under the user are deleted when the user is deleted.
Drop tablespace name is used to delete a tablespace;