1, create a temporary tablespace when creating a tablespace, the DBF file is generally stored in the DataFile file under the folder (usually under the name of the instance folder) can be through the select * from V$datafile; View all data file storage location Create Temporary tablespace tablespace name tempfile '/data/oradata/chuanshu/datafile/tmp_ file name. dbf ' Size 50M autoextend on next 1M maxsize 1 024Mextent Management local;2, creating a formal tablespace create tablespace tablespace name logging datafile '/data/oradata/chuanshu/datafile/ File name. dbf ' Size 124M autoextend on next 1M maxsize 10240Mextent management local; 3. Create User username identified By Passworddefault tablespace table space name temporary tablespace temporary tablespace name; 4, grant to newly created database user grants DBA to username;grant Connect to Userna Me;grant resource to username with admin Option;grant Unlimited tablespace to INSPUR_RMW with admin Option;//grant dba to Username with admin option; ability to complete the function 5, delete tablespace drop tablespace tabaspacename including contents and datafiles;// Delete tablespaces and data files at the same time
Oracle rookie how to create and delete table spaces