The sys user logs in as a DBA under cmd:
Run sqlplus/nolog in cmd.
ThenConn/As sysdba
Note:
1. If it is enabled in tools such as PL/SQL, directly modify the followingCodeMedium[Italic bold Section]Run
2. Make sure the path exists,For example【D: \ oracle \ oradata \ Oracle9i \] is the path of the file to be saved.Exist
/*Four steps */
/* Step 2: create a temporary tablespace */
Create temporary tablespaceUser_temp
Tempfile 'd: \ oracle \ oradata \ Oracle9i \ user_temp.dbf'
Size 50 m
Autoextend on
Next 50 m maxsize 20480 m
Extent management local;
/*Step 2: create a data table space*/
Create tablespaceTest_data
Logging
Datafile 'd: \ oracle \ oradata \ Oracle9i \ user_data.dbf'
Size 50 m
Autoextend on
Next 50 m maxsize 20480 m
Extent management local;
/*Step 2: create a user and specify a tablespace*/
Create userUsernameIdentifiedPassword
Default tablespaceUser_data
Temporary tablespaceUser_temp;
/*Step 2: grant permissions to users*/
Grant connect, resource, DBAUsername;