Home » RDBMS Server » Server Utilities » importing database
importing database [message #73972] Thu, 12 August 2004 23:13 Go to next message
rabia
Messages: 1
Registered: August 2004
Junior Member
i want to convert my data base from sql into oracle
i am trying to import it through the export facility of sql but when i tried to export the views, it gives an error because the syntax of inner and outer join of sql and oracle is diffrent. please tell me what should i do .

Report message to a moderator

Re: importing database [message #73977 is a reply to message #73972] Fri, 13 August 2004 04:54 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
YOu cannot directly migrate from NON-oracle databases to oracle databases.
You can use oracle Migration workbench and there are limitations.
Please have a look here.
http://www.oracle.com/technology/tech/migration/workbench/index.html

Report message to a moderator

Previous Topic: IMP Utility Version doubt
Next Topic: imp ignore=y gives erorr ora-0001
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 18:11:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.