BKS Oracle 10.2.0.1.0 LOG

From DISI
Jump to navigation Jump to search

2006-12-13

  • Create Tablespace TOX20063_DATA -> tox20063_data.dbf

CREATE SMALLFILE TABLESPACE "TOX20063_DATA" DATAFILE '/u01/app/oracle/oracle/product/10.2.0/oradata/orcl/tox20063_data.dbf' SIZE 100M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

  • Create user tox20063

CREATE USER tox20063 IDENTIFIED BY **** DEFAULT TABLESPACE tox20063_data temporary tablespace temp;
GRANT CONNECT, RESOURCE TO tox20063;
GRANT CREATE VIEW TO tox20063;

  • Connect as tox20063

@makobj.sql

  • Imported TOX20063: imp parfile=tox.par userid=tox20063/****

2006-09-25

  • Create Tablespace MDDR20062_DATA -> mddr20062_data.dbf

CREATE SMALLFILE TABLESPACE "MDDR20062_DATA" DATAFILE '/u01/app/oracle/oracle/product/10.2.0/oradata/orcl/mddr20062_data.dbf' SIZE 100M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

  • Create user mddr20062

CREATE USER mddr20062 IDENTIFIED BY **** DEFAULT TABLESPACE mddr20062_data temporary tablespace temp;
GRANT CONNECT, RESOURCE TO mddr20062;
@makobj.sql

  • Imported MDDR20062: imp parfile=mddr3d.par userid=mddr20062/****
  • Truncate Previews: @truncate_previews.sql
  • Create Tablespace ACD20063 -> acd20063_data.dbf

CREATE SMALLFILE TABLESPACE "ACD20063_DATA" DATAFILE '/u01/app/oracle/oracle/product/10.2.0/oradata/orcl/acd20063_data.dbf' SIZE 100M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

  • Create user acd20063

CREATE USER acd20063 IDENTIFIED BY **** DEFAULT TABLESPACE acd20063_data temporary tablespace temp;
GRANT CONNECT, RESOURCE TO acd20063;
GRANT CREATE VIEW TO acd20063;
@makobj.sql

  • Imported ACD20063: imp parfile=acd3d.par userid=acd20063/****

2006-04-25

  • Created Tablespace MDDR20061_DATA -> mddr20061_data.dbf
  • Created User mddr20061
  • Imported MDDR20061: imp parfile=mddr3d.par userid=mddr20061/****

2006-04-08

  • Created Tablespace CMC20041_DATA -> cmc20041_data.dbf
  • Created User cmc20041
  • Imported CMC20041: imp parfile=cmc.par userid=cmc20041/****

2006-03-28

  • Delete user mddr20052
  • Delete user mdlreader/bla
  • Delete Tablespace MDDR20052_DATA
  • Delete Tablespace MDDR20052_TEMP
  • Created Tablespace MDDR20052_DATA -> mddr20052_data.dbf
  • Created User mddr20052
  • Imported MDDR20052: imp parfile=mddr3d.par userid=mddr20052/****
  • Created Tablespace ACD20061_DATA -> acd20061_data.dbf
  • Created User ACD20061
  • Imported ACD20061: imp parfile=acd3d.par userid=acd20061/****
  • Created Tablespace TOXICITY20061 -> toxicity20061_data.dbf
  • Created User toxicity20061
  • Imported TOXICITY20061: imp parfile=tox.par userid=toxicity20061/****
  • Created Tablespace SCD20061 -> scd20061_data.dbf
  • Created User scd20061
  • Imported SCD20061: imp parfile=acdsc.par userid=scd20061/****

2006-03-08

  • Created tablespace
  • Created user mddr20052
  • Imported
  • Created user mdlreader