Oracle Automation / Cloud

Testing transport tablespace - Migrating an Oracle 12c Database to a 18c Pluggable Database in the Oracle Cloud ++++++++++++++++++++++ On-premises 12cR2 database   ++++++++++++++++++++++ Create a tablespace CREATE SMALLFILE TABLESPACE TESTTBS     DATAFILE         '/opt/oracle/oradata/TSOC/tstdb01.dbf' SIZE 300M AUTOEXTEND ON NEXT 1 MAXSIZE 500M  SEGMENT SPACE MANAGEMENT AUTO     EXTENT MANAGEMENT LOCAL AUTOALLOCATE;             Tablespace created. Create the user test in the tablespace SYS@TSOC > CREATE USER test IDENTIFIED BY test DEFAULT TABLESPACE "TESTTBS" TEMPORARY TABLESPACE "TEMP";  2    3 User created. SYS@TSOC >  ALTER USER test QUOTA UNLIMITED ON TESTTBS; User altered. SYS@TSOC > GRANT CONNECT, RESOURCE to test; Grant succeeded.   Create a TEST TABLE ...

Oracle 18c : Database creation using DBCA Click below link -  Oracle18c create-database-using-dbca

Recovering Pluggable Database (PDB) table in Container Database (CDB) Connect to the PDB and create a test table  SQL> connect HR/Password#123@pdb1 Connected. SQL> set echo on SQL> create table EMPLOYESS_TEST as select * from EMPLOYEES; Table created. SQL> select count (*) from EMPLOYESS_TEST;   COUNT(*) ----------        107 SQL> alter session set container=pdb1; Session altered. SQL> select timestamp_to_scn(sysdate) from v$database; TIMESTAMP_TO_SCN(SYSDATE) -------------------------                   3337108 SQL> SELECT NAME, CURRENT_SCN FROM V$DATABASE; NAME      CURRENT_SCN --------- ----------- TESTDB03      3337119 NOTE this SCN which will be used to recover the table. Take an RMAN Backup of the PDB  SQL> ho [oracle@TESTDB03 ~]$  rman target / Recovery Manager: ...

18c- Install Sample Schema  This document is relate to create sample schema under pluggable database. SQL> alter session set container=PDB1; Session altered. Create a tablespace to use for sample schema SQL> create tablespace example01 datafile '/u02/app/oracle/oradata/TESTDB03/PDB1/example01.dbf' size 100M autoextend on next 10M maxsize 500M; Tablespace created. Here I am creating HR sample schema SQL> @?/demo/schema/human_resources/hr_main.sql specify password for HR as parameter 1: Enter value for 1: Password#123 specify default tablespeace for HR as parameter 2: Enter value for 2: example01 specify temporary tablespace for HR as parameter 3: Enter value for 3: TEMP specify log path as parameter 4: Enter value for 4: /u02/app/oracle/oradata/TESTDB03/PDB1 PL/SQL procedure successfully completed. User created. User altered. User altered. Grant succeeded. Grant succeeded. Session...