Adapter script postgres en oracle
Bonjour
je veux convertir un script sql postgres sous oracle
Code:
1
2
3
4
5
6
7
8
9
10
11
12
|
CREATE TABLE MAARCHDRS.af_security
(
af_security_id int NOT NULL,
af_security_label character varying(255) NOT NULL,
group_id character varying(50) NOT NULL,
tree_id character varying(50) NOT NULL,
where_clause text NOT NULL,
start_date timestamp without time zone,
stop_date timestamp without time zone,
CONSTRAINT af_security_pkey PRIMARY KEY (af_security_id)
) |
Mais j'ai cette erreur que j'arrive pas comprendre
Citation:
Erreur commençant à la ligne 1 de la commande :
CREATE TABLE MAARCHDRS.af_security
(
af_security_id int NOT NULL,
af_security_label character varying(255) NOT NULL,
group_id character varying(50) NOT NULL,
tree_id character varying(50) NOT NULL,
where_clause text NOT NULL,
start_date timestamp without time zone,
stop_date timestamp without time zone,
CONSTRAINT af_security_pkey PRIMARY KEY (af_security_id)
)
Erreur à la ligne de commande : 8, colonne : 23
Rapport d'erreur :
Erreur SQL : ORA-00907: parenthèse de droite absente
00907. 00000 - "missing right parenthesis"
*Cause:
*Action:
