1897 sur LDAP


/****/
 CREATE TABLESPACE OCTOPUS_IDX DATAFILE '/opt/app/oracle/product/11.2.0/dbhome_1/dbs/octopus_idx3.dbf' size 500M AUTOEXTEND ON NEXT 64M ;
  CREATE TABLESPACE OCTOPUS_DAT DATAFILE '/opt/app/oracle/product/11.2.0/dbhome_1/dbs/octopus_dat3.dbf' size 500M AUTOEXTEND ON NEXT 64M;
  CREATE TABLESPACE DA DATAFILE '/opt/app/oracle/product/11.2.0/dbhome_1/dbs/da.dbf' size 500M AUTOEXTEND ON NEXT 64M;
   alter database datafile '/opt/app/oracle/product/11.2.0/dbhome_1/dbs/octopus_idx3.dbf' offline drop;
    alter database datafile '/opt/app/oracle/product/11.2.0/dbhome_1/dbs/octopus_dat3.dbf' offline drop;
  drop tablespace octopus_dat including contents;
  drop tablespace octopus_idx including contents;

  reussir a supprimer les tablespaces
/*****/

	SELECT * FROM variante_train vt
LEFT JOIN train t ON t.id = vt.train_id
LEFT JOIN version_scenario vs ON vs.id = t.version_scenario_id
LEFT JOIN scenario s ON s.id = vs.scenario_id
LEFT JOIN relation_annuelle ra ON ra.id = s.relation_annuelle_id
LEFT JOIN relation r ON r.id = ra.relation_id
LEFT JOIN service_annuel sa ON sa.id = ra.service_annuel_id


/*****************************************************/
jdbc:oracle:thin:@212.43.231.137:1521:orcl
DROP USER PPT CASCADE;
CREATE USER ppt IDENTIFIED BY ppt;
GRANT ALL PRIVILEGES TO ppt;
GRANT RESOURCE TO PPT;
SELECT SID, SERIAL#,USERNAME  FROM V$SESSION;
SELECT SID, SERIAL#  FROM V$SESSION WHERE USERNAME='PPTV9';
SELECT USERNAME,SID, SERIAL#  FROM V$SESSION WHERE USERNAME='BLEMOINE';
ALTER SYSTEM DISCONNECT SESSION  '11,10797'  IMMEDIATE;

CREATE USER ppt IDENTIFIED BY ppt;
GRANT ALL PRIVILEGES TO ppt;
CREATE USER octopus IDENTIFIED BY octopus;
GRANT ALL PRIVILEGES TO octopus;

DROP USER pptV10 CASCADE;
CREATE USER pptV10 IDENTIFIED BY pptV10;
GRANT ALL PRIVILEGES TO pptV10;

DROP USER pptV9 CASCADE;
CREATE USER pptV9 IDENTIFIED BY pptV9;
GRANT ALL PRIVILEGES TO pptV9;

DROP USER blemoine CASCADE;
CREATE USER blemoine IDENTIFIED BY blemoine;
GRANT ALL PRIVILEGES TO blemoine;

DROP USER melmouatassim CASCADE;
CREATE USER melmouatassim IDENTIFIED BY melmouatassim;
GRANT ALL PRIVILEGES TO melmouatassim;

CREATE USER labaoud IDENTIFIED BY labaoud;
GRANT ALL PRIVILEGES TO labaoud;
CREATE USER abelkady IDENTIFIED BY abelkady;
GRANT ALL PRIVILEGES TO abelkady;
CREATE USER aboukhellad IDENTIFIED BY aboukhellad;
GRANT ALL PRIVILEGES TO aboukhellad;
CREATE USER snicolas IDENTIFIED BY snicolas;
GRANT ALL PRIVILEGES TO snicolas;
CREATE USER alaire IDENTIFIED BY alaire;
GRANT ALL PRIVILEGES TO alaire;
CREATE USER msuezpanama IDENTIFIED BY msuezpanama;
GRANT ALL PRIVILEGES TO msuezpanama;


select
  substr (lpad(' ', level-1) || operation || ' (' || options || ')',1,90 ) "Operation",
  object_name                                                              "Object"
from
  plan_table
start with id = 0
connect by prior id=parent_id;

ALTER USER ppt ACCOUNT UNLOCK;
CREATE OR REPLACE DIRECTORY exp_dir AS '/opt/app/oracle/oradata';
GRANT READ, WRITE ON DIRECTORY exp_dir TO ppt;
grant exp_full_database to ppt;
 ./expdp ppt/ppt@ORCL schemas=ppt directory=exp_dir dumpfile=export_ppt.dmp logfile=export_ppt.log
 ./impdp aboukhellad/aboukhellad@ORCL directory=exp_dir dumpfile=export_ppt.dmp logfile=export_ppt.log remap_schema=ppt:aboukhellad
 ./impdp labaoud/labaoud@ORCL directory=exp_dir dumpfile=export_ppt.dmp logfile=export_ppt.log remap_schema=ppt:labaoud
 ./impdp ppt/ppt directory=exp_dir dumpfile=export_ppt.dmp logfile=export_ppt.log
 ./impdp blemoine/blemoine@ORCL directory=exp_dir dumpfile=export_ppt.dmp logfile=export_ppt.log remap_schema=ppt:blemoine
 ./impdp blemoine/blemoine@ORCL directory=exp_dir dumpfile=export_ppt.dmp logfile=export_ppt.log remap_schema=ppt:blemoine
 ./impdp abelkady/abelkady@ORCL directory=exp_dir dumpfile=export_ppt.dmp logfile=export_ppt.log remap_schema=ppt:abelkady
 ./impdp snicolas/snicolas@ORCL directory=exp_dir dumpfile=export_ppt.dmp logfile=export_ppt.log remap_schema=ppt:snicolas
 ./impdp alaire/alaire@ORCL directory=exp_dir dumpfile=export_ppt.dmp logfile=export_ppt.log remap_schema=ppt:alaire
 ./impdp msuezpanama/msuezpanama@ORCL directory=exp_dir dumpfile=export_ppt.dmp logfile=export_ppt.log remap_schema=ppt:msuezpanama