Use of Oracle Database

"Oracel method for creating tablespaces"
--Create a permanent table space--
Create tablespace table space name (for example: Table_1)
DataFile ' file path and filename (such as: F:\java\Oracle tablespace. dbf) ' Note: The suffix is BDF
Size table space (for example: 100M)
Autoextend on next each auto-expansion size (e.g. 50m);

--Create a temporary table space--
Create temporary tablespace table space name (for example: Table_1)
Tempfile ' file path and filename (such as: F:\java\Oracle tablespace. dbf) ' Note: The suffix is BDF
Size table space (for example: 100M)
For example:
Create temporary tablespace table_1
Tempfile F:\java\Oracle Table Space \a.dbf
Size 100M

--View tablespace name, ID, file storage location, initial size
Select Tablespace_name,file_id,file_name
bytes
From Dba_data_files
Order by file_id;

"Oracel method to create a user"
Role Permissions:
Connect
Resource

Set user permissions:
In the SQL window
Create User Usename
identified by password;

Grant connect to Usename;
Grant resource to Usename;
Grant create session to Usename;
Grant Create any index to usename;
Grant create any view to Usename;
Grant Select any table to Usename;
Grant update any table to Usename;
Grant Delete any table to usename;

--Authorizing DBA authority to the user
Grant DBA to Usename;

Use of Oracle Database