Migrate Data From Old To New Database

Apr 2, 2008

I need to migrate the data from old to new database. In the old database i have table t_emp

create table t_emp(
EMP_YYYY VARCHAR2(4 BYTE),
EMP_MM VARCHAR2(2 BYTE),
EMP_DD VARCHAR2(2 BYTE),
EMP_HH VARCHAR2(2 BYTE),
EMP_TIME_MN VARCHAR2(2 BYTE),
EMP_TIME_SS VARCHAR2(2 BYTE),
EMP_TIME_HS VARCHAR2(2 BYTE),
EMP_NO);

ex:
1998 02 23 12 01 29

now i have one more new table in new database which contains

Create table t_emp_new
(start_date date);

i need to load all the old historical data into new table using PL/SQL. How can i combine YYYY,MM,DD,HH,MN,SS,HS and insert as a single date.

02:23:1998 12:01:29

View 4 Replies


ADVERTISEMENT

Migrate Data From MySQL Database To 11g Database

Nov 5, 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 2 Replies View Related

Client Tools :: How To Migrate Data From SQL Server To Oracle Database

Jun 13, 2013

how to migrate sql server database to oracle database?

View 2 Replies View Related

Migrate MySQL Database Into Oracle Database?

Sep 11, 2003

I'm trying to migrate a mySQL database into an Oracle database.

View 7 Replies View Related

How To Migrate Database Using RMAN

Jul 19, 2010

I would like to know how to migrate the database from linux to windows using RMAN.

View 4 Replies View Related

SQL & PL/SQL :: Migrate Data From One Schema To Another

Jan 10, 2012

I have a requirement wherein I have to migrate the data from one schema(source) to another(target).The source and target schema contains 50 tables each.For testing purpose two table are shown below

SOURCE>
DROP TABLE anchor;
CREATE TABLE anchor
(
anchor_idNUMBER(5),
angleNUMBER(5,2),
acad_colorVARCHAR2(20),
att_blkVARCHAR2(20)
);
[code]...

I'm able to migrate the data. On an average the each source table contains 50k to 1 lakh records.

View 4 Replies View Related

Migrate Database To Linux And Apply Inc Changes Afterwards

Mar 3, 2012

I need to migrate a 500 GB 10.2 database from windows to linux. Of course I found Alejandro Vargas paper on how to do that ("Database Migration From Windows to Linux Using RMAN"). My problem is that the source database will be up again for 7 days and I need to apply all changes made to the source database to the migrated linux database.

Can I just take all redo log files generated from the source database and apply those to the destination database? I might have a problem with a) file conversion and that the redo log are not in sync with the target database (different check points?).I just found that on an exotic website: "The contents of a redo log file depend on a combination of Oracle version, operating system and server architecture. In general redo logs written on one architecture cannot be read on another. There are a few exceptions to this rule. For example, in Oracle 10.2 a redo log written in Linux can be read by a Windows database."

So if this is true, does it also work the other way AND will the database migration from window to linux create a perfect clone of the database where those redo log files actually can be applied to?

View 1 Replies View Related

Migrate Database From Linux To Solaris?

Sep 12, 2011

We are planning to migate Oracle database from Linux 10gR2 (non-ASM) to Solaris (ASM) and then Oracle upgrade that database from 10gR2 to 11gR2 on Solaris.

View 4 Replies View Related

Backup & Recovery :: How To Migrate Oracle Database From 10g To 11g

May 25, 2012

how to migrate oracle database from 10g to 11g

View 1 Replies View Related

Upgrade :: Migrate Database From Windows To Linux?

May 6, 2013

I need to migrate database from Windows to Linux. The current size is ~50GB.

Current Env:
OS = Windows 2003
DB version = 10.2.0.3

Proposed Env:
OS = Linux
DB version = 11.2.0.2

Would using datapump be a correct choice for this migration? Also do the step below seem correct?

01.     Pre-create tablespaces on target 11g database
02.     Export full database of source 10g database
03.     Copy dumpfile to Destination Server
04.     Grant IMPORT_FULL_DATABASE system privilege to user SYSTEM of target 11g database
05.     Import full database to target 11g database

View 6 Replies View Related

Export/Import/SQL Loader :: Migrate Database Into Different SID

Jul 19, 2012

I need to migrate a 10g database into an 11gR2 on same Red Hat Linux platform (although different servers with different versions of Linux). The difference between the two databases however is the SID, the new one has a different SID which means that the datafiles will be named differently (as our datafile names include the SID) otherwise everything else is the same..

I propose to take the following steps:

- install 11gR2 on the new server

- create the 11gR2 database with new SID using DBCA

- full export 10g database

- full import dump file into 11gR2 database.

I however do not have experience of how this will work with respect to the full import where the datafiles are named differently. For example TABLESPACE TEST in the source database has datafile TEST_SOURCE.dbf but the same TABLESPACE TEST in the target database will have datafile TEST_TARGET.dbf.

Will all the data in the source database be correctly imported into the new database?

View 4 Replies View Related

SQL & PL/SQL :: Migrate Data From Oracle Server To MySql?

Feb 1, 2013

I need to migrate data from oracle server to MySql.

View 14 Replies View Related

How To Migrate Database From Windows 2003 To 2008 Server

Oct 31, 2012

I have to migrate production database version 10gR2 on windows 2003 server to oracle 11gR2 on windows 2008 server...So far i have just installed the oracle software on 64bit windows 2008 server.how to move the data or migrate from old server to new server..

View 1 Replies View Related

Migrate Current Production Database To Test 10.2.0.4 On Windows

Feb 1, 2011

I have to migrate the current production database to test 10.2.0.4 on windows. Any non-export way to upgrade 9i to 10 g?

i have following steps

1) ALTER DATABASE BACKUP CONTROLFILE TO TRACE
2) shutdown oracle 9i database on server A
3) copy database file, controlfile, redolog, and other files to new server B
4) alter the controlfile backup with new location of bdump, udump, and log file and data file locations
5) user oradim ORADIM -NEW -SID SID [-INTPWD PASSWORD ]-MAXUSERS USERS
-STARTMODE AUTO -PFILE ORACLE_HOME\DATABASE\INITSID.ORA
6) start dabase in upgrade mode
7) run catpat.sql and util102.sql
8) take backup
9) open database for users

View 3 Replies View Related

Server Administration :: Migrate And Upgrade Oracle 9i Database To 10g?

Mar 10, 2011

I am looking to migrate and upgrade an Oracle 9i database to 10g.

Would there be any fallout if the characterset were changed from US7ASCII to UTF8?

View 2 Replies View Related

Data Guard :: Migrate From File Based To ASM Storage

May 15, 2012

I have an 11gR2 data base with Local Extent Management and Manual Segment Management. Can Data Guard be used to replicate this instance into ASM storage? [I have multiple long fields (BLOBs and CLOBs) in various tables.]

View 3 Replies View Related

PL/SQL :: How To Migrate Files From Collaboration Plum Tree Server To Oracle Database

Jul 4, 2012

I need to write a procedure to migrate files from Collaboration plum tree server to oracle database server into a table using a BLOB column .

View 2 Replies View Related

Server Utilities :: Using Expdp / Impdp To Migrate 4 TB Database From Solaris To Linux

Aug 4, 2011

I am using expdp/impdp to migrate 4 TB database from solaris to Linux.But the import process is taking forever.

View 13 Replies View Related

Server Administration :: How To Migrate Database From Windows 2003 To 2008 Server

Oct 31, 2012

I have to migrate production database version 10gR2 on windows 2003 server to oracle 11gR2 on windows 2008 server . So far i have just installed the oracle software on 64bit windows 2008 server. How to move the data or migrate from old server to new server .

View 22 Replies View Related

Cloud Service :: How To Migrate / Move Mysql Database Into Cloud

Jul 18, 2013

We have an application which is built on top of mysql DB. Now we are planning to move into Oracle DB cloud share some documents for this migration. 

View 1 Replies View Related

SQL & PL/SQL :: Move Data From One Data To Another Database Using Database Link

Mar 19, 2010

I have written a Database procedure to move data from one data to another database using Database link. When i run that procedure on Sql it is running fine, but i use same procedure in a button in form using "When-Button-Pressed" trigger it generates error, error code is ORA-02055 and ORA-02067.

View 8 Replies View Related

Migrate To Another Disk

Nov 15, 2006

Lets say I have an oracle setup on C: and I decided to delete the oracle in c: and setup a whole new oracle at E: but I want all the data migrate to the new oracle installation in E: How can I perform that?

View 1 Replies View Related

How To Migrate Two Tablespaces Into One

Apr 3, 2013

at my Oracle 11gR2 (11.2.0.3.0) Instance i have two tablespaces that i want to "bundle" into only one tablespace. Herre is the problem, that some of the tables in the two tbalespaces has the same title but some rows of the tables could be not the same.

Is it possible with a kind of migration assistent to migrate two tablespaces into one in that way, that theassistent only writes that rows into the new tablespace, that are not in the tablespace at the moment.

Another way i was thinking about is to have an insert statement coupled with a select statement. The select statement selects all the rows, that are not in the table where i want to migrate in and the insert statement put that selectet rows into the new table.

Is something of that possible?

View 10 Replies View Related

Migrate 1 Table Only

Jun 14, 2013

I want to migrate only  single 1 big table (with 5M rows and LOB. CLOB columns) from sqlserver to oracle.

I tried migration workbench sqldeveloper but I can not follow thru the guide.

Can you give me a link/doc for single table copy/migration? 

 I tried following this >

[URL]....

But I got stock on the diagram because the one I got is different from the figure in the doc guide.

Ths one is from the doc guide above. Note that it has "Migration" tab menu.[URL]...

And this is the latest sqldev 3.2 I got and there is no "Migration" in the menu. Hence I am stuck. I tried to down load sldev 3.0 and still it has no "migration" option.I wish th doc mentioned what sqldev version

[URL]....

View 6 Replies View Related

Migrate From Oracle To Postgres

May 4, 2011

I want to migrate my database from oracle to postgres.There is a lot of compatibility issues. I heard about the tool ora2pr. have been trying to use it but not able to achieve my goal.Has any one used this tool?

View 1 Replies View Related

Reports & Discoverer :: Migrate From 6i To 11g?

Jun 27, 2011

migrating reports 6i to reports 11g. I did some reading up and only found the the document Upgrading Oracle Forms 6i to Oracle Forms 11g 11g Release 1 (11.1.1) E10394-01 which talk about forms migration. I am looking for a reports migration and found no good documentation on it.

1) Can I migrate to 11g directly or should i migrate to 10g first.

2) Can I use the migation assitant for reports migration or is it only for the forms.

3) If i need to recompile the reports in 11g is there a a 11g developer suite that i should use for it.

View 4 Replies View Related

Server Administration :: Migrate From 8.1.7.0.0 To 9.2?

May 20, 2013

I did the following to migrate.

1. After the installtion of Oracle 9.2 I created the service using oradim.

2. Should I need to copy my old datafiles to 9.2 before using the migrate option?

3. Should I need to startup the database before migrate?

View 1 Replies View Related

SQL & PL/SQL :: Migrate Oracle DB To MS/Sql Server?

Mar 5, 2010

We have and oracle 8i database that has an application that has part of it developed by PL/SQL and the other part on portal 309,is it possible to convert to MS/Sql Database,what tool can we use or what steps do we have to go through to achieve this.

View 1 Replies View Related

Migrate Tables To MySQL

May 21, 2013

I want to upload my oracle tables to mysql tables.

View 11 Replies View Related

PL/SQL :: How To Migrate From Sql Server To Oracle

Aug 8, 2012

My requirement is we are planning to migrate the sql server data to oracle. what is the way to do migration from sql server to oracle. if any tools are there for migration.Previous we used sql developer( which is provided by oracle i.e. freeware ) tool but it was created only table structures not ported any data.

View 3 Replies View Related







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