SQL & PL/SQL :: Database Migration Project To Oracle
Nov 8, 2010
I am working on database migration project SQL server to oracle, convert this query sql server to oracle basic thing i change but i still getting following error: ORA-01799: A column may not be outer joined to a subquery.
SELECT
h.unique_id,
h.customer_id, h.sequence_id, h.name_first, h.name_last, h.email,
h.tn_work, h.tn_home, h.tn_cell, h.tn_work_do, h.tn_home_do, h.tn_cell_do, h.primary_contact_id,h.ssn, h.created, h.customer_status_id, h.doi, h.dod,
NVL(CASE WHEN h.primary_contact_id = 1 THEN tn_home WHEN h.primary_contact_id = 2 THEN tn_cell
WHEN h.primary_contact_id = 3 THEN tn_work END, '') AS ext_primary_contact, ext_customer_status_desc FROM customer c
INNER JOIN customer_history h
[code]...
It's been a while since I worked with SQL Plus . I am using Oracle 11g. We are working on a legacy data migration project. I have a table of records with circular dependency records. i am trying to identify the records. I have the foll. columns- Product,Source,target. I want o identify the records which form a loop. For e.g.
Source Target A B B C C D D A
Last record forms a loop-I need to identify these records. My query is below-
SELECT DISTINCT SOURCE,TARGET FROM RULESELIB WHERE CONNECT_BY_ISCYCLE=1 CONNECT BY NOCYCLE SOURCE=PRIOR TARGET;
I ran this query on 2 tables- one with 75000 records and the other with 25000 records. It works fine on the table with 75000 records completes within a minute but it does not complete on the other table. I can't seem to be able to figure out the issue with the query or is there something about the data that is causing this query to loop infinitely?
I wanted to migrate my database from one of the Solaris machine to other solaris(High performance) machine.We are using oracle 9i database.
I wanted to take RMAN backup with oracle 9i database.and wanted to restore that database to other machine and perform recovery.This process will be on production database and requirenement is to reduce downtime.
let me know RMAN backup procedure which will have less downtime of the database.
Which is the best method for migration of database from Oracle 9iR2,10gR2 to 11gR2.
Current Environment Server1 Operating System: Sun OS 5.10 Oracle Database: Oracle Database Enterprise Edition 9.2.0.8 (32 bit) Average Db Size: 600Gb RAc Configuration: No Server2 Operating System: Sun OS 5.10 Oracle Database: Oracle Database Enterprise Edition 10.2.0.3 (64 bit) Average Db Size: 600Gb RAC Configuration: No
Proposed Environment Server1 and Server2 Operating System: Sun Solaris 10 Oracle Database: Oracle Database Enterprise Edition 11.2.0.3 (64 bit) RAC Configuration: No Hardware is New : Yes
The best way to structure my schemas within a single Oracle instance to support multiple project development. At the moment, within an Oracle instance I have Area_Dev and Area1_Test schemas, with the intention that Project Xv1.0 would use Dev schema for development and Test schema for testing.
Lets say I want to start on Project Xv2.0 development while I am still finalizing Project Xv.10 development what is the best way of accommodating that, without creating individual schemas for each project?
"How to Migrate Oracle 11gR2 32bit to 11gR2 64bit on Microsoft Windows"
Currently we are having Microsoft Windows Server 2003 standard Edition service pack 2 and we are trying to migrate it to microsoft windows server 2008 Release 2 standard Edition
I am part of a upgradation and migration proj where an Oracle 9i db on a HP-UX OS is going to be upgraded and migrated as 10g db on a solaris OS environment.I am from the application team(Data warehouse team) and we are yet to allocate a specific DBA for taking care of this activity.
We are still in the requirements stage...different requirements and challenges that should be taken care and would occur in the roadmap of this project from a DBA perspective.All your inputs would be very valuable to me.
Migration from VFP9 to Oracle Database for my personal and microbusiness DBMS.
For a start, having installed Oracle ORACLE win64_11gR2_database (see Attached file) and logged in, how do I create a simple data table and how do I create a front end for the user - a "FORM" to get user input of name, date, bill no etc.,
Attached File(s) ORACLE_win64_11gR2_database_Installer_Success_Files_Where_all_stored_Be_Cautious.jpg ( 194.7K ) Number of downloads: 1
I am migrating one of my live database from 10g to 11g, which is having its standby database.how can we migrate standby database as well in 11g. do we need to create standby database again or is there any steps?
UPDATE projectdetails SET projectdetails.projectname=(SELECT projectid FROM project WHERE projectdetails.projectname = project.projectname);
but it returns with the error: single row subquery returns more than 1 row
I tried in the same PROJECTDETAILS table with another table A3, it works fine. but not for the PROJECT table.
Below is the project table (i have 2055 rows)
projectidprojectname1NEWEST2PARK WEST3THE VISION4PEOPLE'S PARK CENTRE5REFLECTIONS AT KEPPEL BAY6THE CLIFT7CLEMENTIWOODS CONDOMINIUM8HUNDRED TREES9PASIR VIEW PARK10CARABELLE11PARC IMPERIAL
below is the projectdetails table:
ProjectnameCORALS AT KEPPEL BAY20247502294883Strata101 to 05Jun-1399 yrs lease commencing from 20071CORALS AT KEPPEL BAY278688018901475Strata101 to 05Jun-1399 yrs lease commencing from 20071CORALS AT KEPPEL BAY15250502180700Strata101 to 05Jun-1399 yrs lease commencing from 20071ECHELON216298016471313Strata121 to 25Jun-1399 yrs lease commencing from 20121WHITEHAVEN135600012851055Strata101 to 05Jun-13Freehold1
I need to migrate data from Mysql database to Oracle11g database.
a) is there any method available to import the all the sqls like table script,constraint scripts,data(insert ) script from Mysql.so that we can apply the sql directly to the oracle schema after making necessary changes(like datatype).
b) Is there any free tool available for the migration.
I want to migrate our production database from 9.2.0.8.0 to 10.2.0.4.0 through startup migrate ,so request you to kindly provide me a step by step doc or some reference link pertaining with same.
I have one big database which I need to migrate to Oracle, because it rocks with big databases, instead of other databases and when I was made transfer software and all works great except one more think. During this process I found that Oracle normally fill log & undo table, and my question is how to migrate (or can I migrate) database to oracle without filling undo database (deactivate this process) and after that to put database to work normally, because I just need to transfer data as is and from that point Oracle goes on...
I am planning to move the databases in multi master replication from HP-Ux to AIX server. I am planning to use export/import to moving the database. But do I need to drop the replication administrator user before I do export/import?
currently holding 9i database on win2000 and front end is dev4.5 so the thing is want to upgrade by win2008 pn 32bit with 10gdatabase want to keep the front end application as it is 4.5...
will it be compiatble 10g database on 32bit 2008 and front end 4.5developer forms and reports?
can i migrate 9i database to 10g database, what are the steps for full import??
Our Application is on Oracle 10g and we are going to migrate to Oracle 11g.
1) As of now we are using ojdbc14.jar. So if we migrate can we use the same jar or is it mandatory with 11g to use either ojdbc5.jar or ojdbc6.jar. I guess these jar version depends on the version of jdk we are using. But we are using jdk1.5 and still we use ojdbc14.jar which is working fine. So is it like , Oracle 11g can support only jdk1.5 or jdk1.6 ?
2) Is there any effect on the coding part if we change ojdbc14.jar to ojdbc6.jar ?I have seen there are some extra classes used in ojdbc6.jar.
3) Also we are going to migrate the Oracle database from Solaris to AIX. Our application lies on Solaris.So is there any compatibility problem , if our application lies on Solaris and database on AIX ?
Am going to migrate my databases from 10g to 11g.and am unaware of the performance issues in this and how can i increase the performance at database level and what are the possible bottlenecks.
Currently our application running with Database - oracle 10.2 and front-end SAP11.5. We are going to upgrade our database (oracle 10.2) to 11g (version not sure) and upgrading application from SAP 11.5 to 12.2. As part of it i want to know what are all things i want to take care while migration (oracle upgradation) as I'm oracle developer.
1) Is it possible to access objects in 8i database from 11g database using DB link?. (as like 10g to 8i). 2) Is it possible to access objects in DB2 database from 11g database using DB link?. (as like 10g to DB2).
I have a database on Mysql which consists on 40 tables interrelated. My issue is to migrate that DB to Oracle 11g by keeping the same structure (I mean the relation between the differents tables).
In my project, fmb's were written using oracle 9i and now we planned to move them to oracle 10g. The consequences of using oracle 10g to modify the oracle 9i fmb's.
Also will there be any diff in terms of visual if i use oracle 10g to open oracle 9i fmb's.
