How
about trying the other way around - pushing the data from SQLServer to Oracle?
There was a tool in SQL7 (not sure if they still have it in SQL2000 but I should
think they do) called DTS (Data Transformation Service), that will transfer your
tables with the data over to Oracle.. Have a
hi
I am ashar from Karachi,Pakistan.I just wanna know
that are oracle 9i exam guides of oracle press
available in US? there are 4 exams of oracle 9i, are
all 4 books available there.I heard that only oracle
9i sql book is available right now.Please do inform
me.
Ashar
Jyoti,
The Migration Workbench is designed to migrate the
structure and data. It's available as a free download
(once you register) from http://technet.oracle.com
HTH,
-- Anita
--- S.Jyotinarayan [EMAIL PROTECTED] wrote:
I have done a typical installation of Oracle 8i EE.
I have the
Hi,
Ms sql server itself has a migration utility which is better than Oracle's,
and supports more diverse kinds of database and data types.
I myself used that utility for transfering data from text files into oracle
8.1.7
give a try
cheers :)
- Original Message -
To: Multiple recipients
Hi,
Thank you very much. It works.
At 10:40 2001.11.18. -0800, you wrote:
Hi,
Use oemapp in $ORACLE_HOME/bin. oemapp requiers some parameter (that tells
witch program to start (DBA studio among others)). If you call it without
parameters it will tell you possible values.
regards
torben holm
There has been a version of Oracle for Solaris on Intel available for
some time. Unfortunately that time is coming to an end. There will
not be any Solaris Intel Oracle 9, so 8i is the end of the line for the
platform.
Regards,
Chris Gait
--
Please see the official ORACLE-L FAQ:
Hi,
I've installed Morpheus.
Right after that I couldn't attach to Oracle ( 8.1i under Windows Nt),
because the 1521 port was already used.
(that's why the listener couldn't start)
I uninstalled Morpheus but the port is still used.
I've tried other ports but every one seems to be used.
Look in your /etc/services or inetd.conf file.
It sounds like Morpheous still has a listener attached to the port and you need to remove the reverence to 1521. If inetd.conf needs editing you will need to send a kill -1 to the inetd process to re read the inetd.conf
Cheers
Peter McLarty
Hi,
If I have shutdown my database doesn't that mean that all the smon, pmon
processes will be killed???
After I shutdown my db and I do a ps -ef | grep ora I still see pmon, smon,
lgwr etc processes.
I am running HP-UX and v 8.1.7
Cheers,
Sujatha
--
Please see the official ORACLE-L FAQ:
are you running more than one Oracle instance? you should see
ora_sid_smon -- is the value of sid the same as that of the database
that you shutdown?
did the database you think you shut down, shut down properly?
--- Sujatha Madan [EMAIL PROTECTED] wrote:
Hi,
If I have shutdown my database
Hi,
Yes the SID is the same as the one I shut down. Also, when I try and start
the database up it is giving me an ORA-01102 error (Cannot mount database in
exclusive mode at startup).
The other db on the system is shutdown properly.
I had thought that only Win NT gives ORA01102 errors -
Hi
I am not sure if I have understood ur problem
but can u please try this
1. cd $ORACLE_HOME/dbs
2. ls -alt lk*.ora
3. if there is any file by the name
lkdb_name.ora where db_name is the database name
and NOT SID then try removing this file and
starting up
Hi lists,
I have some problem with my listener. That is resolved with the help of
metalink. But I have a doubt in this regard.
When I try to see the status, lsnrctl status 816LISTENER
the statement hung for 10 minutes. I checked metalink and found the
solution was,
probably the size of
13 matches
Mail list logo