Create user profiles for general, update, and batch operations.
- Log on as SYSDBA.
-
Create the general user profile P_General_User with the default database General_Views, 10 GB of spool space, and 0 bytes of temporary space. For example:
CREATE PROFILE P_General_User AS DEFAULT DATABASE=General_Views, SPOOL=10e9, TEMPORARY=0;
-
Create an update user profile P_Update_User with the default database Update_Views and 0 bytes of temporary space. For example:
CREATE PROFILE P_Update_User AS DEFAULT DATABASE=Update_Views, TEMPORARY=0;
-
Create a batch user profile P_Batch_User with 100 GB of spool space and 0 bytes of temporary space. For example:
CREATE PROFILE P_Batch_User AS SPOOL=100e9, TEMPORARY=0;