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 […]
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 […]
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