Pages
▼
Saturday, June 26, 2021
Thursday, June 24, 2021
Saturday, June 19, 2021
Cloning A Schema
Cloning A Schema
Example:
SQL> @cln_user.sql
Enter user to model new user to: SCOTT -----> Existing User
Enter new user name: MQMTEST -----> New User
Enter new user's password: TEST123! -----> New User Password
create user MQMTEST identified by TEST123! default tablespace USERS temporary tablespace TEMP profile DEFAULT;
grant RESOURCE to MQMTEST;
grant CONNECT to MQMTEST;
grant UNLIMITED TABLESPACE to MQMTEST;
alter user MQMTEST default role RESOURCE;
alter user MQMTEST default role CONNECT;
Health Check Script
Health Check Script
Using below script we can database status, lsnrctl status and mountpoint.
vi status.sh
and save!