imarshad
asked on
Conversion from Access to Oracle....
Hi all,
I am trying to convert my Database from Access 2000 format to Oracle 9i..... Is there some freeware/demoware or within Oracle a program that can convert my database from Access to Oracle???
Please note that I donot require the data but only the design of my Access database(Tables only) to be converted into Oracle..... So that I donot need to create the tables all again in Oracle using the Command Prompt Queries.....
Imran
I am trying to convert my Database from Access 2000 format to Oracle 9i..... Is there some freeware/demoware or within Oracle a program that can convert my database from Access to Oracle???
Please note that I donot require the data but only the design of my Access database(Tables only) to be converted into Oracle..... So that I donot need to create the tables all again in Oracle using the Command Prompt Queries.....
Imran
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK I have got it solved..... Restarting my computer was the key....
Imran
Imran
ASKER
I have downloaded and used Migration Workbench.... I am getting some problem with it.... First step was to capture a source Database....
It was done easily.... Then the next step was to create a Oracle Model from the source model..... This was also done without any errors and I can see the tables, indexes etc. in the Oracle Model... The final step is to Migrate Oracle Model to Oracle database.... This is where I am really stuck....
It asks for UserName , Password, Host, Port and SID.... I have an account imran with DBA rights... And also looking into my TNSNAMES.ORA file I have found that my Host, Port and SID are HOST = imran,PORT = 1521, SID = OracleT
ORACLET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = imran)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = OracleT)
)
)
But when I enter these values I get the following error.... "Incorrect login information specified. Ensure that the Host, Port, SID values are correct...."
What could be the problem???
and also another annoying error has occured after using that Migration Workbench.... Here is my log file
SQL*Plus: Release 9.0.1.0.1 - Production on Thu Apr 28 13:48:05 2005
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Enter user-name: imran
Enter password: *****
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production
SQL> connect sys/change_on_install as sysdba
ERROR:
ORA-03113: end-of-file on communication channel
ERROR:
ORA-24313: user already authenticated
Warning: You are no longer connected to ORACLE.
SQL> connect imran/imran
ERROR:
ORA-24315: illegal attribute type
SQL> connect sys/change_on_install as sysdba
ERROR:
ORA-24313: user already authenticated
SQL>
I think both of these problems are interconnected.... Can someone tell me why this has started happening(That I cant switch user once I am logged from a user)? Uptil yesterday this error was not occuring....
Imran