Month: October 2017

October 1, 2017 RMAN backup and logical backup With Different User

Installation/Configurations10gInstallation/Configurations11gInstallation/Configurations12cOracle Database Material

RMAN backup and logical backup With Different User Step 1: Create the user CREATE USER bkp_user IDENTIFIED BY bkp_user DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp PROFILE DEFAULT; GRANT CONNECT TO bkp_user; GRANT exp_full_database TO bkp_user; GRANT imp_full_database TO bkp_user; GRANT recovery_catalog_owner TO bkp_user; GRANT select_catalog_role TO bkp_user; …

October 1, 2017 ORA-01442: column to be modified to NOT NULL is already NOT NULL

Errors/Workarounds10gErrors/Workarounds11gErrors/Workarounds12cOracle Database Material

ERROR Solution : ORA-01442: column to be modified to NOT NULL is already NOT NULL sql> alter table HR.employees modify…

October 1, 2017 How To Move Table to Different TableSpace

APPS DBAAppsDBA ScriptsDatabase ScriptsScripts

How To Move Table to Different TableSpace SYNTAX ALTER TABLE table_name move TABLESPACE tablespace_name (INITIAL=64k MINEXTENTS=1 MAXEXTENTS=UNLIMITED); EXAMPLE ALTER TABLE hr.employee_details move TABLESPACE hr; OR ALTER TABLE hr.employee_details move TABLESPACE hr (INITIAL=64k MINEXTENTS=1 MAXEXTENTS=UNLIMITED);