Edit D:\app\Administrator\product\11.2.0\dbhome

Edit D:\app\Administrator\product\11.2.0\dbhome_1\ord\im\admin\imtab.sql

Rem
Rem $Header: imtab.sql 12-jun-2006.11:24:41 smavris Exp $
Rem
Rem imtab.sql
Rem
Rem Copyright (c) 2002, 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      imtab.sql - Create and populate static tables
Rem
Rem    DESCRIPTION
Rem      Create and populate static Oracle Multimedia tables.
Rem
Rem    NOTES
Rem      Assumes you are connected to ORDSYS (or alter schema to ORDSYS)
Rem      before runnint this script.
Rem
Rem

--==========================================================================
-- Table ORD_USAGE_RECS
--  Stores users that are using Oracle Multimedia
--==========================================================================
-- Column             Description
----------------------------------------------------------------------------
-- USERNAME           User that uses Oracle Multimedia
-- AUX_COUNT          auxiliary count to store extra number information
-- COMPONENT_NAME     which Oracle Multimedia components get used. Use strings
--                    from the following list: IMG, AUD, VID, DOC, DCM, ORD 
--                    (generic)
----------------------------------------------------------------------------
create table ORDSYS.ORD_USAGE_RECS (
  USERNAME              VARCHAR2(30)  NOT NULL,    
  AUX_COUNT             NUMBER,
  COMPONENT_NAME        VARCHAR2(200) NOT NULL
);

--
-- Create and Populate static tables for SQL/MM interface
--
@@ordistab.plb

--
-- Create DICOM repos in ORDDATA 
--
@@ordcrtbl.plb

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de