EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

oracle migration problem  XML

Forum Index » Tuning and Migration Wizard
Author Message
dmitry.bayanov

New member

Joined: 7 Feb 2011 07:49:05
Messages: 3
Offline

I've tried to migrate scheme from oracle and see errors like this:

Error Creating Constraint FK_BASE_PAY_RECEIPT: ERROR: syntax error at or near ")" at position 111
ALTER TABLE PAY_RECEIPT ADD CONSTRAINT FK_BASE_PAY_RECEIPT FOREIGN KEY (PAYRECEIPT_ID) REFERENCES TIGER.null () MATCH FULL ON DELETE NO ACTION


After removing "()" and adding schema name to table:
ALTER TABLE tiger.CALC_ERROR ADD CONSTRAINT FK_CALC_ERROR_TYPE FOREIGN KEY (CALC_ERROR_TYPE_CODE) references tiger.null MATCH FULL ON DELETE NO ACTION;
ERROR: relation "tiger.null" does not exist

Google doesn't know about this problem or may be I ask wrong questions.
Give me some glues how to solve this problem.
Thanks.

Vibhor_K

Senior member
[Avatar]

Joined: 3 Jul 2009 09:46:15
Messages: 518
Offline

Please share the definition of both the tables.

Thanks & Regards,
Vibhor Kumar
Blog:http://vibhork.blogspot.com
[Email] [WWW]
grizzly1

Member

Joined: 17 Feb 2011 00:30:21
Messages: 22
Offline

It was my fault. Oracle user does not had sufficient rights to migrate schema.
dmitry.bayanov

New member

Joined: 7 Feb 2011 07:49:05
Messages: 3
Offline

grizzly1 wrote:It was my fault. Oracle user does not had sufficient rights to migrate schema.

It was my reply.
Something happened with this forum.
 
Forum Index » Tuning and Migration Wizard
Go to:   
Powered by JForum 2.1.8 © JForum Team