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 

Migration Oracle to EnterpriseDB function sys_context  XML

Forum Index » Tuning and Migration Wizard
Author Message
[Post New]1 Apr 2010 15:52:19
    Subject: Migration Oracle to EnterpriseDB function sys_context
[Up]
Bendy_Damen

New member

Joined: 1 Apr 2010 15:39:00
Messages: 2
Offline
Recently started experimenting with EDB trying to migrate our oracle db.
The import failes for a big part due to the function 'sys_context("unknown", "unknown") does not exist'
Anyone care to share the solution or point me in the direction.
[Post New]2 Apr 2010 06:28:50
    Subject: Re:Migration Oracle to EnterpriseDB function sys_context
[Up]
Vibhor_K

Senior member
[Avatar]

Joined: 3 Jul 2009 09:46:15
Messages: 444
Offline
The import failes for a big part due to the function 'sys_context("unknown", "unknown") does not exist'


Currently 8.3R2AS does not support sys_context. However you can create your own function which can give you similar kind of functionality as given below:


Output:
Thanks & Regards,
Vibhor Kumar
Blog:http://vibhork.blogspot.com
[Email] [WWW]
[Post New]2 Apr 2010 11:33:25
    Subject: Re:Migration Oracle to EnterpriseDB function sys_context
[Up]
Bendy_Damen

New member

Joined: 1 Apr 2010 15:39:00
Messages: 2
Offline
Thanks

I will try your solution.
 
Forum Index » Tuning and Migration Wizard
Go to:   
Powered by JForum 2.1.8 © JForum Team