Month: October 2017
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;
GRANT CREATE SESSION TO bkp_user;
Step 2: Connect RMAN with the Above Created User
$ rman
RMAN> connect target bkp_user/bkp_user
RMAN> backup database;
Note: Script can be written and job can be scheduled to take backup.
ERROR
Solution : ORA-01442: column to be modified to NOT NULL is already NOT NULL
sql> alter table HR.employees modify UID not null;
ORA-01442: column to be modified to NOT NULL is already NOT NULL
SOLUTION
ALTER TABLE table_name
ADD CONSTRAINT constraint_name CHECK(column_name IS NOT NULL);
OR
ALTER TABLE hr.employees
ADD CONSTRAINT nn_uid_hr_addrsdtls CHECK(UID IS NOT NULL);
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);