ORACLE to MySQL

yussef · 06-15-2005, 04:01 AM

Ok here is the thing i have to migrate a ORACLE sql query to a MySql script; cqn someone help me do that? pleeaase

here is the code:

Code:

CREATE TABLESPACE TOPUP_DATA
       
       DEFAULT
       STORAGE ( 
       INITIAL 4096000
       NEXT 655360
       MINEXTENTS 1
       MAXEXTENTS 12
       ) 
  ;
CREATE TABLESPACE TOPUP_INDEX
       
       DEFAULT
       STORAGE ( 
       INITIAL 901120
       NEXT 163840
       MINEXTENTS 1
       MAXEXTENTS 12
       ) 
  ;

CREATE TABLE TOPUPOWN.CFG_OPERATOR_CURRENCY (
       COC_OperatorId       VARCHAR2(3) NOT NULL,
       COC_CurrencyDPSKiosk VARCHAR2(3) NOT NULL,
       COC_CurrencyOperator VARCHAR2(3) NOT NULL
)
       PCTFREE 10
       TABLESPACE TOPUP_DATA
       STORAGE ( 
              INITIAL 8
              NEXT 8
              MINEXTENTS 1
              MAXEXTENTS 11
       ) 
;


ALTER TABLE TOPUPOWN.CFG_OPERATOR_CURRENCY
       ADD  ( PRIMARY KEY (COC_OperatorId, COC_CurrencyDPSKiosk)
       USING INDEX
              TABLESPACE TOPUP_INDEX
              STORAGE ( 
                     INITIAL 8
                     NEXT 8
                     MINEXTENTS 1
                     MAXEXTENTS 11
              ) ) ;


CREATE TABLE TOPUPOWN.CFG_OPERATOR_MSG_FIELDS (
       COM_OperatorId       VARCHAR2(3) NOT NULL,
       COM_Order            NUMBER(2) NOT NULL,
       COM_OperatorOpCode   NUMBER(1) NOT NULL,
       COM_OperatorMsgField VARCHAR2(50) NULL,
       COM_DPSKioskMsgField VARCHAR2(50) NULL,
       COM_DataType         NUMBER(1) NULL,
       COM_Long             NUMBER(4) NULL,
       COM_DefaultValue     VARCHAR2(100) NULL
)
       PCTFREE 10
       TABLESPACE TOPUP_DATA
       STORAGE ( 
              INITIAL 32
              NEXT 8
              MINEXTENTS 1
              MAXEXTENTS 11
       ) 
;

THANKS!!

jonaskoelker · 06-15-2005, 07:04 AM

What? You want us to do it for you? Good luck.

davholla · 06-15-2005, 11:42 AM

If you do it yourself and post what is going wrong (if it does) then maybe someone will help.

jonaskoelker · 06-15-2005, 04:21 PM

Quote:

What? You want us to do it for you? Good luck.

Hm... I actually feel guilt about... well... hmm... sounding arrogant.

So I want to make it up to you, OP, by pointing you to an article worth its weight in gold (whatever that means):
http://www.catb.org/~esr/faqs/smart-questions.html

hth --Jonas

chrism01 · 06-16-2005, 01:22 AM

Hint: I think you'll find you can't specify storage in MySQL ...

yussef · 06-16-2005, 02:38 AM

thnx chris...
Yeah i figured this out... can't define storage.
I think I am done with migrating it

Thanks anyway