Thursday, June 10, 2021

Query to create Repository User in Oracle


--Create  a new tablespace:

DROP TABLESPACE infa_repo_dev_ts INCLUDING CONTENTS;

CREATE TABLESPACE infa_repo_dev_ts DATAFILE SIZE 50 M AUTOEXTEND ON NEXT 10 M MAXSIZE UNLIMITED FORCE LOGGING ONLINE FLASHBACK OFF;


--Create the infa_repo_dev database user:

DROP USER infa_repo_dev CASCADE;

CREATE USER infa_repo_dev IDENTIFIED BY DB105you DEFAULT TABLESPACE infa_repo_dev_ts TEMPORARY TABLESPACE temp QUOTA 0 ON USERS QUOTA 0 ON SYSTEM QUOTA 0 ON SYSAUX QUOTA UNLIMITED ON infa_repo_dev_ts;


--Grant necessary privileges and roles to your infa_repo_dev database user:

GRANT CONNECT, RESOURCE TO infa_repo_dev;

GRANT CREATE TABLE TO infa_repo_dev;

GRANT CREATE VIEW TO infa_repo_dev;

GRANT CREATE SEQUENCE TO infa_repo_dev;

GRANT CREATE SESSION TO infa_repo_dev;

GRANT CREATE SYNONYM TO infa_repo_dev;

Query to create Domain User in Oracle


DROP TABLESPACE domain_dev_ts INCLUDING CONTENTS;

CREATE TABLESPACE domain_dev_ts DATAFILE SIZE 50 M AUTOEXTEND ON NEXT 10 M MAXSIZE UNLIMITED FORCE LOGGING ONLINE FLASHBACK OFF;


DROP USER domain_dev CASCADE;

CREATE USER domain_dev IDENTIFIED BY DB105you DEFAULT TABLESPACE domain_dev_ts TEMPORARY TABLESPACE temp QUOTA 0 ON USERS QUOTA 0 ON SYSTEM QUOTA 0 ON SYSAUX QUOTA UNLIMITED ON domain_dev_ts;


GRANT CONNECT, RESOURCE TO domain_dev;

GRANT CREATE TABLE TO domain_dev;

GRANT CREATE VIEW TO domain_dev;

GRANT CREATE SEQUENCE TO domain_dev;

GRANT CREATE SESSION TO domain_dev;

GRANT CREATE SYNONYM TO domain_dev;

Wednesday, June 9, 2021

Informatica Powercenter 10.5 Upgrade Paths

https://docs.informatica.com/data-integration/powercenter/10-5/upgrading-from-version-10-2--10-5-/upgrade-overview/upgrade-paths.html