Oracle DB 12.2.0
RHEL 7.4
Hello,
can anyone please help me to convert the mysql code below?
CREATE TABLE in_2020 (
CALLINGPARTYNUMBER varchar(20) COLLATE utf8_swedish_ci NOT NULL,
CALLEDPARTYNUMBER varchar(30) COLLATE utf8_swedish_ci NOT NULL,
DIALEDNUMBER varchar(30) COLLATE utf8_swedish_ci NOT NULL,
SERVICEFLOW char(1) COLLATE utf8_swedish_ci NOT NULL,
CALLFORWARDGINDICATOR char(2) COLLATE utf8_swedish_ci NOT NULL,
CALLINGCELLID varchar(16) COLLATE utf8_swedish_ci NOT NULL,
DATE datetime NOT NULL,
CALLDURATION smallint(4) unsigned NOT NULL,
TERMINATIONREASON smallint(4) unsigned NOT NULL,
CHARGEPARTYINDICATOR char(1) COLLATE utf8_swedish_ci NOT NULL,
PAYTYPE char(1) COLLATE utf8_swedish_ci NOT NULL,
CALLTYPE char(1) COLLATE utf8_swedish_ci NOT NULL,
ROAMSTATE char(1) COLLATE utf8_swedish_ci NOT NULL,
CALLINGROAMCOUNTRYCODE int(10) unsigned NOT NULL,
CALLINGROAMNETWORKCODE int(10) unsigned NOT NULL,
CALLEDHOMECOUNTRYCODE int(10) unsigned NOT NULL,
CALLEDHOMENETWORKCODE int(10) unsigned NOT NULL,
CALLEDROAMCOUNTRYCODE int(10) unsigned NOT NULL,
CALLEDROAMNETOWRKCODE int(10) unsigned NOT NULL,
SERVICETYPE varchar(20) COLLATE utf8_swedish_ci NOT NULL,
HOTLINEINDICATOR smallint(4) unsigned NOT NULL,
HOMEZONEID smallint(4) unsigned NOT NULL,
USERSTATE varchar(10) COLLATE utf8_swedish_ci NOT NULL,
OPOSITENUMBERTYPE smallint(4) unsigned NOT NULL,
SMSTYPE char(4) COLLATE utf8_swedish_ci NOT NULL,
CHARGEFROMPREPAID int(10) NOT NULL,
PREPAIDBALANCE int(11) NOT NULL,
CDRTYPE char(1) COLLATE utf8_swedish_ci NOT NULL,
BILLEDNUMBER varchar(20) COLLATE utf8_swedish_ci NOT NULL,
FILENAME varchar(256) COLLATE utf8_swedish_ci NOT NULL,
load_date datetime DEFAULT NULL,
SEQ varchar(64) COLLATE utf8_swedish_ci NOT NULL,
COL5 varchar(2) COLLATE utf8_swedish_ci NOT NULL,
COL4 varchar(2) COLLATE utf8_swedish_ci NOT NULL,
COL3 varchar(2) COLLATE utf8_swedish_ci NOT NULL,
COL2 varchar(2) COLLATE utf8_swedish_ci NOT NULL,
COL1 varchar(2) COLLATE utf8_swedish_ci NOT NULL
);
Oracle SQL code:
CREATE TABLE in_2020 (
CALLINGPARTYNUMBER varchar2(20) COLLATE utf8_swedish_ci NOT NULL,
CALLEDPARTYNUMBER varchar2(30) COLLATE utf8_swedish_ci NOT NULL,
DIALEDNUMBER varchar2(30) COLLATE utf8_swedish_ci NOT NULL,
SERVICEFLOW char(1) COLLATE utf8_swedish_ci NOT NULL,
CALLFORWARDGINDICATOR char(2) COLLATE utf8_swedish_ci NOT NULL,
CALLINGCELLID varchar2(16) COLLATE utf8_swedish_ci NOT NULL,
DATE1 timestamp NOT NULL,
CALLDURATION int NOT NULL ,
TERMINATIONREASON int NOT NULL,
CHARGEPARTYINDICATOR char(1) COLLATE utf8_swedish_ci NOT NULL,
PAYTYPE char(1) COLLATE utf8_swedish_ci NOT NULL,
CALLTYPE char(1) COLLATE utf8_swedish_ci NOT NULL,
ROAMSTATE char(1) COLLATE utf8_swedish_ci NOT NULL,
CALLINGROAMCOUNTRYCODE int(10) unsigned NOT NULL,
CALLINGROAMNETWORKCODE int(10) unsigned NOT NULL,
CALLEDHOMECOUNTRYCODE int(10) unsigned NOT NULL,
CALLEDHOMENETWORKCODE int(10) unsigned NOT NULL,
CALLEDROAMCOUNTRYCODE int(10) unsigned NOT NULL,
CALLEDROAMNETOWRKCODE int(10) unsigned NOT NULL,
SERVICETYPE varchar2(20) COLLATE utf8_swedish_ci NOT NULL,
HOTLINEINDICATOR smallint(4) unsigned NOT NULL,
HOMEZONEID smallint(4) unsigned NOT NULL,
USERSTATE varchar(10) COLLATE utf8_swedish_ci NOT NULL,
OPOSITENUMBERTYPE smallint(4) unsigned NOT NULL,
SMSTYPE char(4) COLLATE utf8_swedish_ci NOT NULL,
CHARGEFROMPREPAID int(10) NOT NULL,
PREPAIDBALANCE int(11) NOT NULL,
CDRTYPE char(1) COLLATE utf8_swedish_ci NOT NULL,
BILLEDNUMBER varchar2(20) COLLATE utf8_swedish_ci NOT NULL,
FILENAME varchar2(256) COLLATE utf8_swedish_ci NOT NULL,
load_date timestamp DEFAULT NULL,
SEQ varchar(64) COLLATE utf8_swedish_ci NOT NULL,
COL5 varchar(2) COLLATE utf8_swedish_ci NOT NULL,
COL4 varchar(2) COLLATE utf8_swedish_ci NOT NULL,
COL3 varchar(2) COLLATE utf8_swedish_ci NOT NULL,
COL2 varchar(2) COLLATE utf8_swedish_ci NOT NULL,
COL1 varchar(2) COLLATE utf8_swedish_ci NOT NULL
);
ORA-43929: Collation cannot be specified if parameter MAX_STRING_SIZE=STANDARD is set <<======= what does this error mean?
Should I replace the smallint to int?
What does unsigned mean? should I remove it?
Regards,
Joe