Home » Fusion Middleware & Colab Suite » Business Intelligence » Business Intelligence : Data warehouse creation (ORACLE)
Business Intelligence : Data warehouse creation (ORACLE) [message #681577] Wed, 05 August 2020 05:03 Go to next message
soumyarani
Messages: 1
Registered: August 2020
Junior Member
I am working on a business intelligence module. Since I don't have metadata to create my data warehouse, Is it possible to find a script or any other solution to create that metadata from a simple 2 dimensions database? PS: I'm using ORACLE database
Re: Business Intelligence : Data warehouse creation (ORACLE) [message #681583 is a reply to message #681577] Wed, 05 August 2020 10:58 Go to previous message
John Watson
Messages: 8426
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read the OraFAQ Forum Guide and How to use code tags and make your code easier to read

Do you mean this sort of thing:
orclz> select dbms_metadata.get_ddl('TABLE','DEPT') from dual;

DBMS_METADATA.GET_DDL('TABLE','DEPT')
--------------------------------------------------------------------------------

  CREATE TABLE "SCOTT"."DEPT"
   (    "DEPTNO" NUMBER(2,0),
        "DNAME" VARCHAR2(14),
        "LOC" VARCHAR2(13),
         CONSTRAINT "PK_DEPT" PRIMARY KEY ("DEPTNO")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"  ENABLE
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"


orclz>
Previous Topic: Error starting obiee 12.2.1.3.0
Next Topic: How to create xls template based reports in 11i
Goto Forum:
  


Current Time: Thu Nov 26 15:07:35 CST 2020