|
-
Testing OMWB with Access Database
Hello
I am testing the tool "ORACLE Migration Work Bench".
I wrote a simple Access 2000 database with name=Notes.MDB, and this
structure:
IdNote : Autonumber (main key)
Note : Text (255)
I migrated this database to ORACLE using OMWB. This tool reported 0 errors,
the final DDL is:
CREATE TABLE "NOTES"."NOTES" ("IDNOTE" NUMBER(11) NOT NULL,
"NOTE" VARCHAR2(255 byte),
CONSTRAINT "PK_NOTES" PRIMARY KEY("IDNOTE"))
TABLESPACE "NOTES" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS
255
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
LOGGING
The database works fine until i try to add records, the error is :
ORA-04098: trigger 'NOTES.TR_S_13_1_NOTES' is invalid and failed
re-validation
In effect, the trigger 'NOTES.TR_S_13_1_NOTES' is:
BEGIN
SELECT NOTES.S_IDNOTE.nextval
INTO :new.IDNOTE
FROM dual;
END;
Showing the next error :
Line Number = 2 Column Number = 16 Error = PLS-00302: component 'S_IDNOTE'
must be declared,
While 'S_IDNOTE' exists and it is a sequence with this DDL:
CREATE SEQUENCE "NOTES"."S_IDNOTE" INCREMENT BY 1 START WITH 1
MAXVALUE 1.0E27 MINVALUE 1 NOCYCLE
CACHE 20 NOORDER
What is wrong here?
Can OMWB migrate the Access type Autonumber?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules
|
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL
|
Bookmarks