Knowledge Article
CDB - How to create an Oracle tablespace and userid.
How to create an Oracle tablespace and userid.
BMC AMI Capacity Management
Capacity Management Database
BMC AMI Cost Management, BMC Capacity Optimization for Mainframes, Visualizer
What are the steps required to create an Oracle tablespace and userid? |
Prerequisites: ·Oracle instance preinstalled on a supported UNIX, Linux or Windows server. ·Local or remote access to the above Oracle instance using Oracle’s SQLPlus tool. ·Access to the “system” user or another Oracle user with the DBA role assigned to it. Proceed with the following steps to create an Oracle tablespace and userid that can be used with Visualizer as the Capacity Database. 1. Start the SQLPlus tool and log into Oracle with the “system” or equivalent user. 2. Modify the following DDL SQL to meet your needs. CREATE TABLESPACE "<ts_name>" LOGGING DATAFILE '<ts_datafile_path+filename>' SIZE <datafile size in MB> AUTOEXTEND ON NEXT <next_extent_size> MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; CREATE USER <userid> IDENTIFIED BY <password> DEFAULT TABLESPACE <ts_name> TEMPORARY TABLESPACE <temp_ts_name> PROFILE DEFAULT ACCOUNT UNLOCK; GRANT CONNECT TO <userid>; GRANT RESOURCE TO <userid>; GRANT UNLIMITED TABLESPACE TO <userid>;
3. Below is an example what should be seen if the tablespace and userid are created successfully. 4. The tablespace (database) and user are now ready to be used. |
Attachment(s):