Migration From VFP9 To Database

Jul 19, 2013

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

View 1 Replies


ADVERTISEMENT

Upgradation And Migration Of 9i Database On HP-UX OS To 10g Database On Solaris Environment

Dec 29, 2010

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.

View 2 Replies View Related

Migration Of Whole Database?

Dec 20, 2010

we are planning to do the migration from 10g to 11g and from old servers to new servers.

View 1 Replies View Related

Standby Database Migration

Nov 19, 2012

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?

View 3 Replies View Related

Database Migration With Oracle 9i?

Mar 18, 2013

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.

View 4 Replies View Related

Data Migration From MySQL Database

Oct 31, 2008

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.

View 1 Replies View Related

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]...

View 4 Replies View Related

Server Administration :: Reg Database Migration

Jun 26, 2012

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.

View 2 Replies View Related

Performance Tuning :: Big Database Migration?

Jul 4, 2012

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...

View 4 Replies View Related

Replication :: Database Migration From HP-Ux To AIX Server

Oct 29, 2010

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?

View 1 Replies View Related

Server Administration :: Migration Of Database

Jan 20, 2013

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??

View 1 Replies View Related

Ways Provided For Database Migration Except Datapump?

Jul 2, 2013

what are the ways provided by oracle for database migration,except datapump? and which one is recomended

View 1 Replies View Related

RAC & Failsafe :: Single Instance - Migration To Database

Oct 20, 2010

2 Database.

TP1 Database - Oracle RAC 11g (2 Node)
TP2 database - Single Instance

Is it possible to migrate from RAC to Non-RAC(Single Instance)?

Our requirement is, 3 Oracle Schemas@TP1(having DW data) we need to move it to TP2 Database.

View 4 Replies View Related

Oracle Database Migration From 9iR2 / 10gR2 To 11gR2

Apr 22, 2013

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

View 2 Replies View Related

Oracle Standalone Database To (RAC) Real Application Cluster Migration

May 16, 2011

How to migrate Oracle Standalone Database to Oracle Real Application Cluster?

View 1 Replies View Related

Server Administration :: Oracle Database Migration From 11gR2 32bit To 64bit?

May 28, 2012

"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

View 4 Replies View Related

Migration From Oracle 10g To 11g?

Apr 26, 2011

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 ?

View 1 Replies View Related

ASM Migration From One Storage To Another

Oct 4, 2011

we are moving datacenter from one place to another where existing datacenter has got ASM(RAC env) with HP storage which needs to be moved into target datacenter for EMC storage.basically How ASM can be disassociate from source HP storage then associate target EMC storage with very minimal down time.

what are all the ways and all step by steps required for the same.

View 1 Replies View Related

DB Migration From Oracle 10g To 11g?

Sep 1, 2013

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.

View 1 Replies View Related

IBM AIX Server - Migration From 10g To 11g?

Dec 23, 2011

tell the steps for migration from 10g to 11g on IBM AIX SERVER?

View 1 Replies View Related

SQL & PL/SQL :: Migration Of Three Tables

Aug 29, 2013

Data migration for three tables. I have three table which are

1.npi_p_mig contain four fields (pr_id,mi_id,qty,sl_dt,fac_code)
2.np_detail(pr_id,mil_id,qty,sl_dt,facility)
3.np_ref_tab(facility,fac_code),

I need to migrated the data from based on two tables (np_detail,np_ref_tab) to new table npi_P_mig(pr_id,mi_id,qty,sl_dt,fac_code) table. i need sql script to migrate above two table to new table (npi_P_mig) .

View 4 Replies View Related

Forms :: Migration 5i To 6i

Dec 23, 2010

I am migrate to forms 5i to 6i. , compile are complete but following error are generate when running the form

[12/23/10 12:29:14 India Standard Time]::Client Status [ConnId=0, PID=2052]
>> ERROR: Abnormal termination, Error C0000005 ACCESS_VIOLATION

View 3 Replies View Related

Forms :: Migration From 6i To 11g

Oct 25, 2012

Is the oracle migration assistant a utility with the oracle forms 6i distribution? Or do I need to download it from somewhere else? Is there a license required? Is there a disadvantage of using Oracle Application Express for the migration from oracle forms 6i to 11g.

View 1 Replies View Related

Forms :: Migration To 6i?

Apr 20, 2012

We have an application running on Forms 5.0.6.8.0 and Reports 3.0.5.8.0 for the past 10 years... I have two main issues from the begining could not sort to-date... Issues are:

1. I use host() to call reports,for ex:
a) I run a report works fine
b) Now I goto any other master screen and just query some data
c) Now I want to run any of the reports, nothing works..
To generate the report I have to open another instance of application then I can run the report... In this instance again same story repeats... I dont know what is the problem...

2. We are financial company, lot of dependancy on excel ... I want export reports to excel but there is no option...

View 4 Replies View Related

RAC & Failsafe :: DB Migration To New SAN?

Apr 30, 2012

We have to perform migration for our RAC database to new SAN that is at new data centre. Since OS is IBM AIX, we can take backup from mksysb for VG and and storage will migrate data from OLD SAN to NEW SAN.

But even we restore VG and SAN data but since our old SAN is emc and new SAN is hitachi, so disk path for all the asm disk group will be changed.

So is there will be any way to rename this disk path for disk group..

View 1 Replies View Related

Data Migration From 9i To 11g R2

Mar 9, 2011

We have our current production running on 9i and eventually want to migrate to 11g-r2. But the challenges are as follows:

9i production is running in San Francisco data center. 11g-r2 Production already setup up and running in Atlanta data center.

The database size is around 2 TB running on 9i. We are looking to transfer this to 11g-r2 and wondering, what options we have at our disposal: I was looking into EXP/IMP, but somebody said, dblinks will be much faster and reliable than EXP/IMP.

View 10 Replies View Related

SQL & PL/SQL :: Migration From Oracle 10.2 To 11

May 7, 2012

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).

View 7 Replies View Related

Forms :: Migration From 4.5 To 10g

Jan 27, 2010

I am converting an application initially written in Forms 4.5 to Forms 10g. Currently I am facing 2 issues regarding the change in functionality from 4.5 to 10g.

There are 5 items in a block and the WHEN-NEW-FORM-INSTANCE trigger sets one of the items (the third item ITEM3) programmatically to display only and assigns a value to it. There is a WHEN-VALIDATE-ITEM in that item (At that point it doesn't fire and this is OK).

When the user navigates from ITEM1 to ITEM2 and then to ITEM4 (because ITEM3 is disabled) the WHEN-VALIDATE-ITEM of ITEM3 does not fire immediately. In forms 4.5/6i the trigger was firing and a lot of functionality was built on that behavior.

In forms 4.5 it was possible to cancel a long running query (during EXECUTE QUERY) using Control-C. The control C doesn't seem to work in form 10g. Is there any way to force a cancel of a long query in 10g?

View 2 Replies View Related

Upgrade :: Migration From 10g To 11g?

Nov 2, 2012

my current database version is 10.2.0.3.0 and we are going to migrate our database to 11.2.0.3 .

Can we directly migrate database to 11.2.0.3 or will i require to apply any patch before this ?

View 2 Replies View Related

Migration From Windows To Linux

Mar 31, 2008

Where to get the Metalink Doc-ID for Migration from windows 2000 to Linux.

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved