잡학문구

Create a User in your Autonomous Transaction Processing Database

Once you have connected SQL Developer to your Autonomous Transaction Processing database, use a SQL Developer worksheet to define a create user statement to create the user atpc_user. In the next tutorial, you will create sales history tables in the atpc_user schema and load data into these tables from an object store.

1. Open a SQL Developer worksheet and run the following SQL statements to create the user atpc_user, swapping in a password with the guidelines provided in the following Note section.
   create user atpc_user identified by "<password>";
   grant dwrole to atpc_user;
2. 
   
   Description of the illustration sql_developer_commands_create_atpc_userNote: Autonomous Transaction Processing requires strong passwords. The password you specify must meet the default password complexity rules. This database checks for the following requirements when you create or modify passwords:
   
   • The password must be between 12 and 30 characters long and must include at least one uppercase letter, one lowercase letter, and one numeric character.
   • The password cannot contain the username.
   • The password cannot be one of the last four passwords used for the same username.
   • The password cannot contain the double quote (") character
   
   Note: Autonomous Transaction Processing databases come with a pre-defined database role named DWROLE.
   This role provides the common privileges for a database user: CREATE ANALYTIC VIEW, CREATE ATTRIBUTE DIMENSION, ALTER SESSION, CREATE HIERARCHY, CREATE JOB, CREATE MINING MODEL, CREATE PROCEDURE, CREATE SEQUENCE, CREATE SESSION, CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREATE VIEW, READ,WRITE ON directory DATA_PUMP_DIR, EXECUTE privilege on the PL/SQL package DBMS_CLOUD  
   
   



3. In the next tutorial, "Connecting SQL Developer to Autonomous Transaction Processing", you will connect SQL Developer to your Autonomous Transaction Processing database as user atpc_user, and define SH tables(sales history tables from an Oracle sample schema) for that user. Later, you will load data into those tables from an Object Store.

Create SH Tables in your Autonomous Transaction Processing Database

After you have connected SQL Developer to your Autonomous Transaction Processing database, use a SQL Developer worksheet to define CREATE TABLE statements to create the SH tables (sales history tables from an Oracle sample schema) in the atpc_user schema. In the next tutorial, you will load data into these tables from an object store.  

1. Copy and paste this code snippet to a SQL Developer worksheet.worksheet. Run the script to create the SH tables.

   

   Description of the illustration sql script to create sh tables

Examine the SH Tables that you Created

Now that you have created the SH tables, take a moment to examine them. In the next tutorial, you will load data into these tables from an object store.

1. Note that the new tables also appear in the SQL Developer Connections panel. 

   

   Description of the illustration list of new tables in atpc_user  
2. Examine the details of each column of the CHANNELS table.
   

   

   Description of the illustration details of the CHANNELS table
   
3. Click the Data tab of the CHANNELS table. Note that so far, you have defined tables, but these tables are not yet populated with Data.
   

   

   Description of the illustration no data yet in CHANNELS table
   
4. In the next tutorial, "Loading Your Data", you will load data from an object store into these SH tables.

Next Tutorial

Loading Your Data to Autonomous Transaction Processing