Import Oracle database dump
Hello, Today we will see how to import oracle dumped database. Create a tablespace with 2Go memory Shell CREATE TABLESPACE <tablespace name> DATAFILE 'cecm.dbf' SIZE 2048M ONLINE; 1 CREATE TABLESPACE <tablespace name> DATAFILE 'cecm.dbf' SIZE 2048M ONLINE; 2. Create <user> Shell CREATE USER <username> IDENTIFIED BY <password>; 1 CREATE USER <username> IDENTIFIED BY <password>; 3. give him dba access : Shell GRANT dba TO <username> WITH ADMIN OPTION; 1 GRANT dba TO <username> WITH ADMIN OPTION; 4. copy dump into the dump directory : Shell mv oracle_dump.DMP /u01/app/oracle/admin/XE/dpdump/ 1 mv oracle_dump.DMP /u01/app/oracle/admin/XE/dpdump/ 5. Finally, launch the dump : Shell impdp <username>/<password> dumpfile=oracle_dump.DMP logfile=out.log full=y; 1 impdp <username>/<password> dumpfile=oracle_dump.DMP logfile=out.log full=y; ...
Read MoreOracle – Supprimer une contrainte et ces index
Bonjour à tous, récemment au travail j’ai rencontré des problèmes dû au fait qu’en supprimant une contrainte sur une table oracle, les index n’était pas correctement supprimé. Voici un exemple de requete qui supprime une constrainte et ces index : Oracle PL/SQL alter table ACT_RE_PROCDEF drop constraint ACT_UNIQ_PROCDEF; DECLARE COUNT_INDEXES INTEGER; BEGIN SELECT COUNT(*) INTO COUNT_INDEXES FROM USER_INDEXES WHERE INDEX_NAME = 'ACT_UNIQ_PROCDEF'; IF COUNT_INDEXES > 0 THEN EXECUTE IMMEDIATE 'DROP INDEX ACT_UNIQ_PROCDEF'; END IF; END; alter table ACT_RE_PROCDEF add constraint ACT_UNIQ_PROCDEF unique (KEY_,VERSION_, TENANT_ID_); 1234567891011121314151617 alter table ACT_RE_PROCDEF drop constraint ACT_UNIQ_PROCDEF; DECLARE COUNT_INDEXES INTEGER;BEGIN SELECT COUNT(*) INTO COUNT_INDEXES FROM USER_INDEXES WHERE INDEX_NAME = 'ACT_UNIQ_PROCDEF'; IF COUNT_INDEXES > 0 THEN EXECUTE IMMEDIATE 'DROP INDEX ACT_UNIQ_PROCDEF'; END IF;END; alter table ACT_RE_PROCDEF add constraint ACT_UNIQ_PROCDEF unique (KEY_,VERSION_, TENANT_ID_); ...
Read More