All Questions

Tagged with
Filter by
Sorted by
Tagged with
0
votes
1answer
61 views

ORACLE DMU (database migration assistant for unicode) Tool

Reading the documentation for Oracle DMU tool, when I try the step create a step for DMU Repository tablespace the document says to use the result of the query for initial size. However; I could not ...
0
votes
3answers
58 views

Error messages while migrating from Oracle to MSSQL [closed]

I got these error messages when migrating from Oracle to MSSQL (Unfortunately, the error messages are in German languages) Verletzung der PRIMARY KEY-Einschränkung "DTR_PK". Ein doppelter Schlüssel ...
0
votes
0answers
20 views

SSMA - Sysdb - Tables Missing

Based on my test, when I use SSMA for Oracle.8.4.ExtPack.exe to install, after the installation, I can see the table ssma_oracle.bcp_migration_packages and other tables are not in the sysdb database, ...
0
votes
1answer
36 views

Issue migrating oracle package to postgres using ora2pg

I was migrating an oracle(12c) package to postgres(Enterprise db 10.5) using ora2pg. The migration run successfully for most of the functions. However, one function referenced multiple times in the ...
0
votes
0answers
56 views

Migrating from windows-1252 to UTF-8 character set

I'm thinking of migrating my database (oracle) from windows-1252 to UTF-8 by doing the following: export all data (backup) truncate all tables run alter database character set import data back Is ...
0
votes
1answer
61 views

Migration to Oracle Autonomous Database

What prerequisites, if any (such as version number, database objects in use), does an existing Oracle database have to fulfil in order to be able to migrate it straight away to Oracle Autonomous ...
0
votes
1answer
402 views

Migrating triggers, functions and procedures from Oracle to PostgreSQL

We run a Java based application which uses Oracle as its backend. While they are rather simple and don't overly use Oracle specific functions, we have lots of triggers, function and procedures written ...
0
votes
3answers
53 views

Database Migration [closed]

We are migrating our one of testing servers. My questions are: What is a best way to migrate database from one server to another? If I do data migration through export/import utility (Full database ...
-1
votes
1answer
272 views

How to copy data and schema from oracle to ms sql

Is there any easy way to copy data and schema from oracle to ms-sql. i am using sql server 2017 and oracle sql developer Version 4.1.4.21 I need one time migration. I am using SSMA but getting ...
0
votes
1answer
67 views

Moving Oracle / Oracle datafiles to different file system on Linux

We have Oracle installed on /root, which is now running out of space due to increasing data in Oracle database. On the same machine we have another file system with free space. I want to know the ...
0
votes
2answers
70 views

How to make a backup of an Oracle database that does not mess up the regular backup cycle?

Goal I want to move a database from server A to server B. Both server have the same technology so one way is to shutdown the source database, copy data files,control file, redo logs, parameter file ...
0
votes
1answer
3k views

is it possible to use utl_file_dir = '*' scope = spfile in 12c

Oracle 12c has deprecated utl_file_dir = '*' scope = spfile, but I need to use this functionality. Is there any option to do it? Is it possible to give permission using Java classes?
0
votes
1answer
643 views

how to replace dbms_reputil.from_remote in oracle 12.2.0.1 since All objects removed except REPLICATION_IS_ON, _OFF and _ON

how to replace dbms_reputil.from_remote in oracle 12.2.0.1 since All objects removed except REPLICATION_IS_ON, _OFF and _ON
1
vote
0answers
129 views

Migrate Firebird to Oracle

I have about more than 250 Firebird local databases and several server databases. The way they are connected is such: A block of almost 50 local databases, 1 on each PC, connect to 1 server database. ...
1
vote
2answers
365 views

Migrate SQL Server to Oracle 11G Offline (OMWB)

So, I'm having some difficult to migrate SQL Server to Oracle. This time there appears a new error message: Migration actions have failed check the migration reports for details. : Capture Offline ...
0
votes
3answers
819 views

How to transfer data from denormalized table to normalized tables in Oracle?

Hi I currently have a database set up with a table like this: Grades: student name|class name|overall|hw|test|quiz|project|val where student name and class name are type varchar2 with the rest being ...
0
votes
1answer
97 views

MOVING TO ORACLE 12c

I have an rman backup of 11.2.0.2. Also I have installed 12c on a separate server. Can I move my backup to 12c. if yes? Please guide me how to do it? Appreciate your comments and answer.
1
vote
0answers
449 views

Bidirectional realtime synchronization between Oracle and SQL Server tables

I have to sync data between Oracle and SQL Server database tables. And I'm actually looking for some advice on which technologies to use or how to address this. At the moment I'm doing the Oracle → ...
0
votes
2answers
904 views

Cloning the database to another server with raw data files

I'm trying to clone the database of server 1 to server 2 with raw data files. I'm using Linux 7 and Oracle 11g R2. I have the instance running with same SID in Server 2 but file structure is different....
1
vote
2answers
391 views

How to translate SQL Server stored procedure into Oracle stored procedure?

This is my SQL Server stored procedure which is below: CREATE PROCEDURE flight_details AS BEGIN SELECT Airline.Airline_No, Airline_Name, Airplane.Airplane_No, Airplane_Name, Flight.Flight_No, ...
0
votes
1answer
543 views

Loading Oracle ctl export file into postgresql

I have a number of tables exported from an oracle database in the form of Ctl files with that data included within the file. Im looking for a way to import these into postgresql but the the ...
0
votes
1answer
26 views

how to Upload xml data to db Table by check primary key in oracle

i want to upload xml file data to db table by checking the primary key and wants update the each row data.Here trid getting as a primary key.example OFF 1133 2388977 is their any solution ...
0
votes
1answer
202 views

How to make datapump apply directly to the destination schema

I have a schema on a server that returns and half I need to replicate it to another server, so I'll la and do an expdp on server1 sending the file to server2 and do an impdp. Solve the problem. ...
0
votes
0answers
61 views

Efficiently moving Data from CSV to SQL 2014

I am working on a requirement to transfer almost 1 TB of data from a CSV file to SQL server. Which is the fastest way to do this? I am considering bulk copy and came across this link which actually ...
1
vote
1answer
618 views

Ora2pg - migration Oracle db into postgreSQL without instalation of Oracle

I have sql file with structure:create table,insert into table, contrains, etc.... This script was generated in oracle, and my job is tranform this script into compatible script for postgreSQL. Does ...
3
votes
1answer
258 views

online Oracle database migration to different Oracle database release

We currently have the following environment Source data center: 1) OS: Oracle Enterprise Linux 5.7 2) DB: Oracle Database Enterprise Edition 10.2.0.1.0 3) Server Type: Physical Server 4) Data ...
0
votes
2answers
196 views

Import datadump in schema mode [closed]

why am I encountering this error when executing impdp command? My command looks like this: impdp directory=dp_dir dumpfile=testdb.dmp logfile=testdb.log Error message: ORA-39002: invalid ...
-1
votes
2answers
466 views

Does exporting in schema mode also exports grants?

Hi guys I a complete newbie in oracle databases and I'm just curious about when you do an export datapump in schema mode, does it also exports grants?
1
vote
0answers
50 views

Better mode in export datapump

I'm a complete newbie in oracle databases. I'm just curious on what mode is better when you want to migrate your database to another host by using data pumping. Lately, I'm having a problem on import ...
0
votes
1answer
4k views

ORA-00959: Tablespace '$name' does not exist when using impdp

I'm new at Oracle databases. I'm executing an impdp command and encountered this error: ORA-00959: tablespace '$name' does not exist. Is the only thing I can do is to create the $name tablespace?
2
votes
1answer
2k views

Migrate Sql Server 2014 to Oracle 12c: best options

I need to migrate an Sql Server 2014 database across to Oracle. The best option is to use SQL Developer which comes with the migration tool. Having gone through the steps described it fails due to ...
1
vote
1answer
604 views

ORA-28031 while attempting to rebuild or drop index

I am in the process of using Data Pump to setup a copy of an Oracle database from 11.2.0.3.0 on Windows to 11.2.0.4.0 on Oracle Linux. I have had a few issues with invalid objects which I have managed ...
0
votes
0answers
697 views

Migrating database from Oracle to SQL Server [closed]

I need to migrate an Oracle database in which there is more than one table. I created new SSMA project and grant all privileges to my Oracle user, but still an error occurs: User does not have ...
1
vote
1answer
5k views

Oracle Migration Upgrade 11g to 12c New Server

I'm fairly new to Oracle databases and have been tasked with assessing the implications of upgrading our application's database from 11g to 12c. I have managed a successful in-place upgrade but a ...
4
votes
2answers
14k views

Copy Oracle database 10g to 12c

I need to copy an Oracle 10g (10.2.0.4.0) database (150GB) to an Oracle 12c (12.1.0.2.0) database. Both are Standard Editions. What method should I use? Target is on a different server - empty ...
2
votes
2answers
15k views

Creating a “database link” from Oracle to SQL Server [duplicate]

Is there a way for Oracle to read from SQL Server? We are basically trying to read from a SQL Server table and update the information in Oracle. We used to have a database link in Oracle to another ...
3
votes
1answer
4k views

Migrating BLOB in Oracle into PostgreSQL

I use the data type BLOB in an Oracle table to store images and document files. Now for Postgres(9.4.5), I have two options, i.e., BYTEA or OID. With consideration of passing the params (SAVING) ...
0
votes
1answer
1k views

Movement of Standby database from one location to another location

Looking for help on below mentioned process: We are planning to move the standby database from Location A to Location B. I need your help to move this database using lift and drop method, by shutting ...
0
votes
1answer
1k views

Migrate/Export DB from Oracle 11g Enterprise to Oracle 11g Express

So I'm a DBA newbie and I've got an Oracle Enterprise server running in production with the following information under All Reports -> Data Dictionary Reports -> Version Banner, under "...
0
votes
2answers
1k views

Handling lossy data before character- set migration

I am trying to migrate a database from US7ASCII to AL32UTF8 using CSSCAN. During the initial scanning using CSSCAN we have found the presence of lossy data both in data dictionary() and application ...
2
votes
0answers
335 views

Migrating schema from Entity-Attribute-Value (EAV) model to proper tables

I have an Entity-Attribute-Value (EAV) database in Oracle 11. For many, many reasons, I would like to model this using actual tables. Changing all the client code at once is not possible. Existing ...
0
votes
3answers
1k views

Best Approach to Migrating Oracle to MySQL - Run on EC2 in AWS

I'm trying to migrate an Oracle schema as well as all of the data within the DB to a MySQL database. I want to then make an EC2 app on AWS to kick off whatever I've written for this. Are there any ...
-3
votes
1answer
129 views

How to migrate a database from SQL server to Oracle? [closed]

I have been assigned a task to migrate a database from SQL server to Oracle. But I have no idea about how to do it. Also, is there any need to change the existing data model?
0
votes
2answers
367 views

Strategies to import big data into Oracle

What strategies are available to import about 500 million small transactions every day from an external system? Oracle becomes very slow with very frequent commits. The transfer process which is ...
0
votes
1answer
253 views

Oracle Database Migration using Oracle SQL Developer

I've 2 Oracle database on different machines [I connect to them via oracle SQL Developer Now I am planning to have machine 3 which will consolidate both Oracle instances on one new node Question is ...
3
votes
1answer
481 views

Migration From Oracle to PostgreSQL Encoding Errors

I'm working on migrating data from an oracle database to a postgresql database. I running into a problem where I export the data from oracle, using sql developer, and importing it into postgresql. ...
0
votes
1answer
1k views

Oracle copy DB from one windows server to another

I am not an Oracle DBA but looking for the best approach to copy/clone an Oracle database from one windows server to another, here is my configuration and my requirements: Configuration Server 1 (...
1
vote
1answer
2k views

What's the fastest way to migrate an Oracle database from Unix to Linux?

We have an Oracle database installed on AIX 7.1, and now we want to migrate our database instance to RedHat 6.2. The RedHat server has Oracle 11.2 installed already. What's the fastest way to ...
2
votes
1answer
436 views

migration of oracle xe 10 to xe 11 fails with wrong paths used in the import

I'm following the documentation to upgrade an OracleXE 10.2 database to OracleXE 11.2. The export succeeded without any problem, the import (on another machine with XE 11) fails though. The log file ...
3
votes
1answer
665 views

Migrating Oracle to MySQL: MySql Workbench Not Available

I am currently trying to migrate information from a query of a remote Oracle database to a local MySQL database. I have poked around and have found it has been frequently suggested to use the ...