Importing sql server 7/2000 database to OracleHi,
Is it possible to import a MS sql server 7 or 2000 database into Oracle?
Also, if this is possible, would it be better to just import tables and no
stored procedures?
thanks,
Ellie
E Sullivan wrote:
> Hi,
>
> Is it possible to import a MS sql server 7 or 2000 database into Oracle?
> Also, if this is possible, would it be better to just import tables and no
> stored procedures?
>
> thanks,
>
> Ellie
What do you mean by "import"?
If you mean dump the data as a delimited text file and use SQL*Loader.
Yes.
But do keep in mind you will need to translate some data types and
autonumbering columns do not exist.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)
Thanks, Daniel. Yes, that is what I want. Now about the autonumbering
columns: as long as we aren't going to add to the database and expect
autonumbering, I can still have that column, right? That's what it sounds
like.
thanks again.
"Daniel Morgan" <damorgan@x.washington.edu> wrote in message
news:1077639180.433784@yasure...
> E Sullivan wrote:
>
> > Hi,
> >
> > Is it possible to import a MS sql server 7 or 2000 database into Oracle?
> > Also, if this is possible, would it be better to ju...
SqlSpecDo you wish you had comprehensive, easily navigable documentation for
your SQL Server, Oracle, Analysis Server, MySQL, and Access databases?
Are you a SQL Developer or DBA that just inherited a huge, complex
database with no supporting docs and don't know where to start
learning how it's put together?
Are you an independent contractor working with SQL Server, Oracle,
Analysis Server, MySQL, or Access? Your clients would LOVE you if you
could provide comprehensive documentation about the databases you
build.
Are you a Project Manager who is tired of developers making changes to
databases on live servers and not updating the corresponding spec?
SqlSpec will make sense of it all and generate easy-to-read docs for
you for any database on the following platforms:
* SQL Server 2000/2005
* Oracle 9i (and above)
* MySQL 5.0 (and above)
* Analysis Server 2005
* Access 97/2000/XP/2003
SqlSpec generates documentation in two formats: HTML or CHM. HTML is
useful for publishing your documents on the web or an intranet site.
CHM is useful if you want a single, compact file containing all your
documentation about one or more databases. The CHM is indexed so it is
easily searchable for any keyword. This way you can easily determine
which objects reference the "EmployeeID" column, for example.
You can download a fully featured trial version here: http://www.elsasoft.org
...
moving oracle database server into a new serverHi all
I will be moving oracle from one Solaris server into another Solaris
server, the IP address and box name will be changed. Oracle version is
8.1.7 and O/S is 5.8 on both servers ( just different O/S patch).
Does any one know what I need to do in order to get oracle up and
running again on the new server. I know that I will need to change the
tnsnames.ora and listner.ora, but is there anything else that I need
to do?
Thanks
Teresa
Teresa wrote:
> Hi all
>
> I will be moving oracle from one Solaris server into another Solaris
> server, the IP address and box name will be changed. Oracle version is
> 8.1.7 and O/S is 5.8 on both servers ( just different O/S patch).
> Does any one know what I need to do in order to get oracle up and
> running again on the new server. I know that I will need to change the
> tnsnames.ora and listner.ora, but is there anything else that I need
> to do?
>
> Thanks
> Teresa
When I do this with windows boxes I either:
#1 Install oracle on the new box, create a new database and
export/import from old db to new db
#2 Copy datafiles, init, sqlnet, tns.. etc over from coldbackup or
shutdown old_database, startup nomount and recreate the controlfile to
fit new environment.
#3 Restore from online backup of old_database and apply redo logs, again
recreating the controlfile to fit the new env. (I usually only do this
for "practice" and for creating a development copy of a prod db)
#2 ...
How do I check which Oracle Patches are appplied to an Oracle DataBase ServerI would like to know if someone could help me with this topic, I'm
traying to analize and chek which Oracle Patches are appplied to an
Oracle DataBase Server
>chek which Oracle Patches are appplied to an Oracle DataBase Server
If they were applied with oPatch, then "opatch lsinventory" should show
you what's there.
If you did not use oPatch, then I have no clue. ;-)
BD wrote:
> >chek which Oracle Patches are appplied to an Oracle DataBase Server
>
> If they were applied with oPatch, then "opatch lsinventory" should show
> you what's there.
>
> If you did not use oPatch, then I have no clue. ;-)
For better or worse ( we know the answer ) opatch is the tool that
install patches from oracle support.
"If you did not use oPatch" ... what?
>"If you did not use oPatch" ... what?
In my 8i environments, there are separate scripts that are run - for
example, for a cpu, it would be 'install_cpu.sh'.
In those cases, I really don't know how (if) one can confirm which
patches have been applied to an environment.
...
Oracle 9i Database Server on Windows 2003 ServerI am wondering if we can install this Server on Windows 2003 Server without
any problems.
Is there anybody that did that before?
Thanks in advance if someone know the answer.
Yvon Bouchard, B. Sc. Computer Science
Teacher
http://info.cegepat.qc.ca/siteyvon
I've installed it on windows 2003 enterprise ed. about 1 month ago without
any problem.
I've installed the version 9.2.0.1 with the patch to 9.2.0.3.
9.2.0.3 is the only version certified by oracle for win 2003.
Ciao
"Yvon Bouchard" <yvon.bouchard@cablevision.qc.ca> ha scritto nel messaggio
news:QCLvb.21605$ZF1.2102185@news20.bellglobal.com...
> I am wondering if we can install this Server on Windows 2003 Server
without
> any problems.
> Is there anybody that did that before?
> Thanks in advance if someone know the answer.
>
> Yvon Bouchard, B. Sc. Computer Science
> Teacher
> http://info.cegepat.qc.ca/siteyvon
>
>
>
Yvon Bouchard wrote:
>
> I am wondering if we can install this Server on Windows 2003 Server without
> any problems.
> Is there anybody that did that before?
> Thanks in advance if someone know the answer.
>
Although I have not installed on Windows 2003 myself, I know of several
such installations and all occurred without issue.
I do note that Oracle has a separate download (CD set) for the WIndows
2003 compared to NT/2000/XP, so I suspect the install for the latter may
not be ...
tcl database connection for Oracle MySQL PostgreSQL Sybase "Microsoft SQL Server 2000 Desktop Engine" DB2 Interbase/Firebird SQLite Microsoft AccessHello everyone,
There are many people that are looking for/missing the support for
their database within TCL. Somehow this was overlooked:
http://sqlrelay.sourceforge.net/index.html
It has native TCL API and supports most popular databases.
One problem: It doesn't have production ready support on Windows, but
for the lucky people who use Linux/Unix, it seems to be an excellent
solution, while TDBC is being developed.
One small correction, the TCL part of the db connection will work just
fine on Windows connecting to sqlrelay running on Linux/Unix (which,
in turn, can connect to the database running on Windows :) ). What
doesn't have production ready support (according to developers) is
sqlrelay running on Windows.
...
Multiples Instance of SQL server 2000/SQL server 7.0 on Windows server 2003Hi,
Is it possible to install on a Windows server 2003,
SQL SERVER 2000 in the folowing configuration :
SQL server 7.0 as a default Instance
and
SQL server 2000 as a named instance.
Thanks for your answer.
riless (g.carali@voila.fr) writes:
> Is it possible to install on a Windows server 2003,
> SQL SERVER 2000 in the folowing configuration :
>
> SQL server 7.0 as a default Instance
>
> and
>
> SQL server 2000 as a named instance.
If SQL 7 can be installed on Win2003, yes. But I would not really
expect SQL 7 to be welcome on Windows 2003, although I don't...
sql command to list all databases in the oracle serverHi,
could u help me, what is the sql command to list all existing databases
in a oracle server?
dalu.gelu@gmail.com wrote:
> Hi,
>
> could u help me, what is the sql command to list all existing databases
> in a oracle server?
Please read the Oracle Concepts Manual.
There are Instances and Databases and Schemas.
There is no such thing as multiple databases in a single instance.
There are multiple schemas! (select distinct owner from dba_tables)
Multiple instances can only be listed on O/S level.
--
Sybrand Bakker
Senior Oracle DBA
only one database in oracle server, see v$database view
sybrandb wrote:
> dalu.gelu@gmail.com wrote:
> > Hi,
> >
> > could u help me, what is the sql command to list all existing databases
> > in a oracle server?
>
> Please read the Oracle Concepts Manual.
> There are Instances and Databases and Schemas.
> There is no such thing as multiple databases in a single instance.
> There are multiple schemas! (select distinct owner from dba_tables)
> Multiple instances can only be listed on O/S level.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
dalu.gelu@gmail.com wrote:
> could u help me, what is the sql command to list all existing
> databases in a oracle server?
Depends what you mean by "database" and "server". If "server"
means a physical, computer server and you want to see all the
Oracle instances ("databases"), on most ...
Sqlserver 2000 database on Oracle 9 serverHi!
how could I link a sqlserver 2000 database on a oracle 9 server.
or
how could I import a sqlserver 2000 database in oracle 9 server.
Thanks
Hubert Mayr wrote:
> Hi!
>
> how could I link a sqlserver 2000 database on a oracle 9 server.
> or
> how could I import a sqlserver 2000 database in oracle 9 server.
>
> Thanks
>
Oracle Transparent Gateway.
Heterogeneous services.
ASCII files.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)
Daniel Morgan <damorgan@x.washington.edu> wrote in message news:<1073922683.284194@yasure>...
> Hubert Mayr wrote:
>
> > Hi!
> >
> > how could I link a sqlserver 2000 database on a oracle 9 server.
> > or
> > how could I import a sqlserver 2000 database in oracle 9 server.
> >
> > Thanks
> >
>
> Oracle Transparent Gateway.
> Heterogeneous services.
> ASCII files.
I have read some articles about this, but I am a little confused about
the difference between "Oracle Transparent Gateway" and "Heterogeneous
services".
I want to create a database link so that the application (logging on
to Oracle) will not know whether the table is actually stored in
Oracle or in SQL Server.
Do I need Oracle Transparent Gateway to make this possible or ...
Restore of Case Insensitive Database to a Case Sensitive DatabaseYesterday I received a response to my CI/CS Collation problem and the
recommendation was to try and restore a CI Collation database to a CS
Collation database. After creating a blank CS database a full restore
(Force restore over existing database) does change the Collation to
CI. I'm unsure as to how I can restore without changing the
Collation. Any suggestions?
Hi. Check out this article:
http://www.sql-server-performance.com/vg_database_comparison_sp.asp
If appears that if you can put the CI db on another box and create a
linked server to it you should be able to bring over every...
How to write shell script to export oracle 8.1.6 database to import oracle 10g databaseHi,
I am trying to write or understand the conj process for export the data
from oracle 8i to oracle 10g database. I have constraint that the
previous loaded data into oracle10g should not be deleted or replace by
newly imported database.
Regards
Nikhil
...
Oracle databases on a serverI have Oracle installation on a SUN UNIX server. I tappears that it is
running Oracle 10.2 and Solaris 8.
I want to find out how many databases are installed on this server.
Would it be true to say that all databases installed on this server
are listed in tnsnames.ora where the 'HOST' entry points to this
server?
On Feb 20, 9:00=A0am, p...@qantas.com.au wrote:
> I have Oracle installation on a SUN UNIX server. I tappears that it is
> running Oracle 10.2 and Solaris 8.
>
> I want to find out how many databases are installed on this server.
>
> Would it be true to say that all databases installed on this server
> are listed in tnsnames.ora where the 'HOST' entry points to this
> server?
No, these might be different *services* served by the same instance.
The first place to look at is /var/opt/oracle/oratab file, which
should list all Oracle instances on your host. If your Oracle
installation follows OFA (Optimal Flexible Architecture,) which is
usually true, count $ORACLE_BASE/admin/<dbname> directories - each
database should have its own directory under admin. Alternatively, you
can also count spfile<SID>.ora files in $ORACLE_HOME/dbs directory.
Hth,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
On 20 Feb, 06:00, p...@qantas.com.au wrote:
> I have Oracle installation on a SUN UNIX server. I tappears that it is
> running Oracle 10.2 and Solaris 8.
>
> I want...
Updating Oracle database from SQL Server as linked tableI have a medical records system where parts live in Oracle and parts
live in SQL Server. I'm trying to inactivate a lot of patients who
haven't been seen since the conversion by updating them on the SQL
Server side and then updating the Oracle side to match. I'd like to be
able to use the following query:
UPDATE server..user.table
SET OraField1 = 'I'
WHERE OraField1 = 'A'
AND OraField2 IN (
SELECT SQLfield2
FROM SQLTable
WHERE SQLField1 = 1
)
However, when I do this, I get an error saying that the field "was
reported to have a DBTYPE of 130 at compile time and 5 at run time".
This appears to mean that there's a field on the Oracle side that was
defined as Number without any precision information. How can I rewrite
this query to actually work? OpenQuery doesn't seem like it will do
what I want, and I don't want to accidentally inactivate everyone in
the database...
Thanks!
"Garrett Fitzgerald" <SarekOfVulcan@gmail.com> wrote in message
news:cefcd14e-1ffa-4c85-9fa3-6dab448fc3c4@c65g2000hsa.googlegroups.com...
>I have a medical records system where parts live in Oracle and parts
> live in SQL Server. I'm trying to inactivate a lot of patients who
> haven't been seen since the conversion by updating them on the SQL
> Server side and then updating the Oracle side to match. I'd like to be
> able to use the followi...
importing blobs and other monstrosities from oracle 10g to sql server 2000Hi.
I was trying yesterday to import an oracle schema via DTS into my ms sql
server 2000 system, but it seemed to choke a bit on what I believe are blob
fields.
Can anyone recommend a way or a pointer to a way accomplish this, or is oracle
10g and sql server 2000 to separate in how advanced they are?
Thanks
Jeff
Jeff Kish
...
Oracle 8i and 9i Database concurrently on Windows 2000 ServerI am trying to install Oracle 8i and 9i Database server on same machine
, but I am getting getting various errors..
I cannot start TNSListener servive of both 8i and 9i simultaneously.
If i try to login to 8i Database using scott / tiger or try to create a
database , I get "Tns protocol error".
Cannot complete Net8 configuration and Database configuration while
installing 8i Database server.
Please help me for same as i tried installing 8i for many times.
I have kept different home names for both 8i and 9i.
Forms 6i and D2k 4.5 is already installed on the M/c.
Is there any sequence for these installations.
"Mayura" <mayura.jadhav@gmail.com> ha scritto nel messaggio
news:1140675978.019512.31510@z34g2000cwc.googlegroups.com...
>I am trying to install Oracle 8i and 9i Database server on same machine
> , but I am getting getting various errors..
>
> I cannot start TNSListener servive of both 8i and 9i simultaneously.
> If i try to login to 8i Database using scott / tiger or try to create a
> database , I get "Tns protocol error".
Check MetaLink Note 306905.1.
Regards,
Dimitre
Mayura wrote:
> I am trying to install Oracle 8i and 9i Database server on same machine
> , but I am getting getting various errors..
>
> I cannot start TNSListener servive of both 8i and 9i simultaneously.
> If i try to login to 8i Database using scott / tiger or try to create a
> database , I get "Tns protocol erro...
Re: Accessing MS SQL server or ORACLE database from the HP3KFolks,
One small clarification to my previous question:
We are not trying to migrate our IMAGE data to another platform. We are
trying to provide an enhancement where data that already exist in a
database on another platform can be viewed, extracted and used to
"complete" an existing entry in the IMAGE database, thus eliminating the
need for the user to manually 're-enter' the data.
Regards
Paul Christidis
===============================================================================
Folks,
I was asked the following question today and decided to turn to y...
US-PA: Philadelphia-Oracle/SQL Server Database Administrator**************************************************************
JobCircle.com is a regional job board serving all industries
and occupations in the PA, NJ, DE, NY, MD, and DC areas.
We offer a regional job board, online learning, and regional
job fair events for jobseekers who live in our areas of focus.
To Learn More:
Job Board: http://www.JobCircle.com?source=ng
eLearning: http://www.JobCircle.com/courseware?source=ng
Job Fairs: http://JobCircleJobFairs.com?source=ng
**************************************************************
Job Title: Oracle/S...
automate startup /shutdown oracle database server 9i on redhat advance server 3.0how i automate the oracle database 9i on RedHat Advance server 3.0 automatic
startup and shutdown database in linux advance server 3.0
On Mon, 2 Aug 2004 17:06:37 +0500, "Kashif Hameed" <kashifh@shoa.net>
wrote:
>how i automate the oracle database 9i on RedHat Advance server 3.0 automatic
>startup and shutdown database in linux advance server 3.0
>
as usual: just read the documentation
http://download-uk.oracle.com/docs/pdf/A96167_01.pdf
(and please do so prior to posting as to avoid this type of questions)
--
Sybrand Bakker, Senior Oracle DBA
...
from sql server to oracle to ANOTHER oracleI have a linked server to a oracle db, that works.
I have to write a query from sql server that connecto to the oracle
server, and the use a database link from that oracle db to another
oracle db. I'm not able to find the syntax.
I try to write something like
SELECT * FROM
LINKTOORACLE..mm510TAL.CSHDET@ORAGATE2
but it does not work
questions
1) is is possible to use nested dblinks ?
2) if so, how ?
thank you!
On Nov 10, 10:57=A0am, Alberto Marchi <alberto.rol...@gmail.com> wrote:
> I have a linked server to a oracle db, that works.
>
> I have to write a query from sql server that connecto to the oracle
> server, and the use a database link from that oracle db to another
> oracle db. I'm not able to find the syntax.
>
> I try to write something like
>
> =A0SELECT * FROM
> =A0 LINKTOORACLE..mm510TAL.CSHDET@ORAGATE2
>
> but it does not work
>
> questions
> 1) is is possible to use nested dblinks ?
> 2) if so, how ?
>
> thank you!
use a synonym that points to the second linked table?
On Nov 10, 9:27=A0pm, onedbguru <onedbg...@yahoo.com> wrote:
> On Nov 10, 10:57=A0am, Alberto Marchi <alberto.rol...@gmail.com> wrote:
>
>
>
>
>
> > I have a linked server to a oracle db, that works.
>
> > I have to write a query from sql server that connecto to the oracle
> > server, and the use a database link from that oracle db to another
> > oracle db. I...
Re: Accessing MS SQL server or ORACLE database from the HP3K #3In a message dated 7/8/03 5:23:24 AM Pacific Daylight Time,
pete@bookware3000.ca writes:
> It's not MS SQL or Oracle but for what it's worth, we once had a Cobol
> program
> accessing a PostgreSQL database that resided on a Linux server by using the
> C
> libraries included with Mark Bixby's PostgreSQL port.
>
I for one would absolutely love to see an example of that! Sometime soon (?)
I hope to be able to finally spend some time working with PostgreSQL on MPE
and/or Linux. Having a known working example of how to access it via COBOL is
a great ...
Re: Accessing MS SQL server or ORACLE database from the HP3K #6On July 9, 2003 11:23 am, Duane Percox wrote:
> * Performance was not that great so you wouldn't want to use this
> for production, but proof of concept and for learning it is ok.
Do you have any performance numbers for it all on Linux?
Pete
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
...
Re: Accessing MS SQL server or ORACLE database from the HP3K #3Paul,
if nothing else helps, you could use Java and JDBC with the JDBC
driver of the respective target database. A small example showing
access to an Image/SQL database can be found on the following web
page (and can be adjusted to use an MSSQL or Oracle JDBC driver
and database URL/logon fairly easily)...
http://www.editcorp.com/Personal/Lars_Appel/JavaDemo/ -> JdbcProgram
Calling Java from COBOL as a subprogram, however, is probably not
the way that I would go, if exploring this road. I would probably
let a program similar to the above run as a "gateway" in a sep...
Access database(Jet Engine) and SQL Server or SQL Server expressHi,
I am trying to find out what are the big differences between access
database Jet engine and SQL Server? If I have serveral web
applications (same content different copies) running as different
sites(on IIS), each site using an access as a back-end database, all
sites will be running simultaneously, all the access databases are on
the same machine, on this approach, does each copy of access has its
own Jet engine to handle database transaction or only has one Jet
engine with multiple threads handles multiple copies of access
database. Also, I'd like to know what kind database, and data...
SN#22938 Oracle Database 11g vs. Microsoft SQL Server 2008SYSTEM NEWS FOR SUN USERS
Vol 145 Issue 5 2010-04-01 Article 22938 from section "Oracle"
An Edison Group Comparative Management Costs Study
An Edison Group report offers a comparative management costs study
revealing how the Oracle Database widens the manageability lead over
Microsoft SQL Server 2008. The study shows how Oracle Database 11g
can save 43% in time and 41% in database management costs over
Microsoft SQL Server 2008.
Details at http://sun.systemnews.com/g?A=22938
Have a custom version of 'System News for Sun Users...