menggunakan object sequence untuk mengenerate urutannya.
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of Aan Isnaini
Sent: Friday, May 12, 2006 10:53 AM
To: [email protected]
Subject: Re: [indo-oracle] Execute file SQL
Pak ferry,
terimakasih atas sarannya.
dan kayaknya udanh nyerah deh masalah migrasi. sulitnya minta ampun oracle
:) ..atao karena saya yang baru nich..
dan kayaknya perintah Sql yang saya export dari Mysql tdk dikenali oleh
Oracle spt;
"Id" bigint(20) NOT NULL, "Level" int(4) NOT NULL default '0',"Status"
varchar(10) NOT NULL default 'Inactive'
,PRIMARY KEY ("Id")
) AUTO_INCREMENT=28 ;
saya coba buat di SQLplus:
SQL> CREATE TABLE "authtickeruser_tbl" (
2 "Id" number NOT NULL,
3 "Username" varchar(50) NOT NULL ,
4 "Password" varchar(50) NOT NULL ,
5 "GroupId" varchar(50) NOT NULL,
6 "Level" number NOT NULL,
7 "Status" varchar(10) NOT NULL,
8 "Desc1" varchar(50),
9 "Desc2" varchar(50),
10 "Desc3" varchar(50),
11 "Desc4" varchar(50),
12 "LastLogin" date NOT NULL ,
13 "CountLogin" number NOT NULL ,
14 "Deleted" varchar(1) NOT NULL,
15 PRIMARY KEY ("Id")
16 ) AUTO_INCREMENT=28 ;
) AUTO_INCREMENT=28
*
ERROR at line 16:
ORA-00922: missing or invalid option
mohon ada yang bisa memberi referensi buat table dan tipe data yang ada di
oracle, khususnya buat suatu data yanng auto increment dan sebagai primary
key dan buat .
kalo memungkinkan info buku (yang indo- biasanya praktis dan cepat nyarinya)
yang bagus, simple buat tabel-tabel :)
terima kasih
----- Original Message -----
From: Ferry
To: [email protected]
Sent: Friday, May 12, 2006 9:54 AM
Subject: Re: [indo-oracle] Execute file SQL
pak Aan,
Coba lakukan Copy & Paste dari file SQL ke SQLPlus window
utk memeriksa statement mana yg tidak bisa dikerjakan di Oracle.
Jadi proses Copy & Paste dikerjakan per setiap statement DDL/DML.
IF (semua ok ) THEN
Pasti bisa dibuka misalnya dg cara ini SQL> @D:\mysql.txt
ELSE (jika pada Copy & Paste ada statement yg tidak bisa dijalankan) THEN
1. please check syntaks SQL statementnya agar sesuai dg spek Oracle.
Tindakan uni tidak perlu dilakukan jika statement SQL nya mengikuti
standar SQL92
2. Jika statement OK, please check lagi DATA TYPE yg disupport utk
Oracle.
ENDIF
selamat mencoba
ferry sends.
----- Original Message -----
From: "Aan Isnaini" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, May 11, 2006 1:07 PM
Subject: [indo-oracle] Execute file SQL
> Dear All,
> Aku baru nyoba Oracle 10g, dan aku harus migrasi database yang lama
(MySql) ke Oracle ini.
>
> Adakah tip dan trik untuk migrasi databse ini?
>
> yang aku lakukan...di Mysql aku export SQL buat tabe- tabel beserta isi
datanya.
> tetapi di SQLplus coba aku buka sql tadi, muncul response;
> SQL>
> SP2-0423: Illegal GET command
> SQL>
>
> mohon trips dan trik.
>
> Sebagai info aku juga udah install JDevelopper 10g ... masih bingung liat
lingkungan baru :)
>
> makasih
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [EMAIL PROTECTED]
> Website: http://indo-oracle.lizt.org (NEW)
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.vze.com
> Yahoo! Groups Links
>
>
>
>
>
>
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
SPONSORED LINKS Membership database software Database mortgage software Pda
database software
Database management software Oracle database administration Oracle database
management
YAHOO! GROUPS LINKS
Visit your group "indo-oracle" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
Send instant messages to your online friends http://asia.messenger.yahoo.com
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
YAHOO! GROUPS LINKS
- Visit your group "indo-oracle" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
