Data Structures Used In Oracle Database
Oct 29, 2012Which Data Structures are used in oracle database management system for sorting,searching,inserting? Means in SQL.
View 7 Replies
ADVERTISEMENT
Migrating From One Database To Another (Table Structures Slightly Changed)
Aug 20, 2008We have a requirement where we need to migrate data from a legacy system (Oracle 10g) to our database (Oracle 10g again).
The thing is that the table structures will be slightly different between the two. Our current structure has some fields added/removed as well as some tables added/removed. But by and large the databases would be similar (about 75%).
While migrating I would need to map the fields in the source and destination manually. I would also need to populate some data to the fields that have been newly added.
Is there any way to do this? I was checking out Oracle SQL developer but could not proceed much.
Precompilers, OCI & OCCI :: NULL Values In C Structures?
May 18, 2010I use a cursor to select records from a database table into a C structure as follows...
{
int iLoop = 0;
int iResult = 0;
[Code]....
The otc_multiplier field is NULL. As is the to_date sometimes. However, when I output the records later, the entries where the to_date is NULL come out fine (no value). But the otc_multiplier is getting output as 0.0 using...
// this is output later in another fuction using the following..
sprintf(newRecord, "%.1f",daServiceRecs->itemMultiplier);
If using c structures in this manner, what is the method for ensuring that numeric values are set to NULL when required?
Client Tools :: Comparison Of Object Structures In Different Environment
Jul 13, 2010I want to determine the process which will give the difference of object structures in different environments.
View 10 Replies View RelatedData Guard :: Apply Patches On Oracle Database With Logical Standby Database?
Apr 22, 2011I got a primary database with a logical standby database running Oracle 11g. I got two client applications, one is the production site pointing to the primary one, another one is just a backup site pointing to the logical one.Things will only be written into the primary database every mid night and client applications can only query the database but not add, update nor delete.And now, I want to apply the latest patch on both of my databases. I am also the DNS administrator, I can make the name server pointing to the backup site instead of the production one.I want to firstly apply the patch on the logical one, and then the physical one.
I found some reference which explains how to apply patches by adopting "Rolling Upgrade Method". however, I want to avoid doing any "switch over" mentioned in the reference because I can make use of name server. Can I just apply patches as the following way?
1)Stop SQL apply
2)Apply patches on logical standby database
3)let the name server point to the backup site
4)Apply patches on the primary database
5)Start SQL apply
6)Let the name server point back to the production site
Convert Oracle Database (schema Data) To Postgresql Database
Oct 11, 2012i want to convert oracle database(schema data) to postgresql database
which tool would be best and url to download and steps to convert from one database to another ?
Implementing Data Masking In Oracle 11g Database?
Sep 26, 2013I have question regarding data masking. Currently we are using Oracle 11g database , we are thinking of implementing data-masking feature in 11g. Is this can be done by adding any package to it.
View 4 Replies View RelatedData Guard :: Installation In Oracle 10g Database?
Sep 14, 2010I am planning to use Data Guard facility in Oracle 10g database.
1) I would like to have a standby database, which can be used if the primary goes down and also for reporting and other queries (read-Only).
2) What is the difference between Physical and Logical standby database. I have to explain non-technical users (management) regarding this.
3) What is Sync and Async redo log apply?
4) When i manipulate data (Insert,Delete,Update) in logical standby database, will these changes reflect in Primary database synchronously?
5) Which type of REDO APPLY is better: Managed Recovery Process(MRP) or Real Time Apply(RTA)?
6) can the redo data be deleted if its obsolete or is it deleted automatically by oracle?
7) If i want to take backup, should i take it from primary or standby database? If standby, then the database should be in which mode (Read-only or Recovery Mode)
How To Import Data From Informix To Oracle 10g Database
Dec 12, 2012I am working on informix 7.25SE version I need to import data from informix to oracle 10g data base .
View 5 Replies View RelatedData Guard :: Oracle Standby Database Recovery
Mar 31, 2011i have done oracle data guard between two databases (database A is the primary) and (database B is the standby), and it was working fine for two weeks, then the network admin did some changes on the firewall on standby side, which made the primary database can not write on standby redo log , so archives was generated on primary and do not generated on standby by, now we solve the firewall probelm and new archives generated on primary is generated on atandby too, but now i have a gap in archives on standby database and standby database now is not synchronized with primary database, and data changes happen on primary is not reflected on standby, also archives that were generated on primary and did not generated on standby during the problem time is not registered in V$ARCHIVED_LOG neither on primary database nor on standby database
View 1 Replies View RelatedWindows :: Import Ms Project Data Into Oracle Database?
Sep 5, 2012Is there any method to import Ms Project data into Oracle Database.
View 1 Replies View RelatedSQL & PL/SQL :: Interfacing Data From Oracle Database To External System
Feb 24, 2012I have an issue with the text area column(Column name-Text) while interfacing the data from oracle database to external system.The data in database is saved as:
This is test entry for commentfield.
testing the script
Pre-production
23-FEB-2012
We want all the line breaks to replaced with a space or a comma. to implement this i have used to simple select as :
Select Replace(text,chr(10),'')
From paymemo
where referencepkey = (select pkey from paymain where ID = 'DED-520074 505354DN6 2012-02-04 00:06:48');
This is not working because of type conversion issues.
Security :: How To Mask Data In Oracle 11g Database Release 1
Oct 16, 2012how to mask data in oracle 11g database release 1
my environment is
Database: 11g release 1
os: AIX 6 (64 bit)
GC:10g release 1
Globalization :: Having A Oracle Database That Stores Data In Different Languages?
May 1, 2013it is possible to have a oracle database that stores data in different languages.
I have gone through few blogs which says Oracle supports Unicode characters & UTF8 supports all languages including multi-byte.
I would like to know what are the languages supported by oracle 10G.
SQL & PL/SQL :: Oracle Database 10g - Data In Column Stored In Different Character Set
Sep 23, 2010Oracle database version is : 10G.
When we try to query a column from a table the output is shown as "?????". Seems the data in that column is stored in a different character set, which is not recognised while displaying the output. The column size is 35byte.
The nls parameter table shows the character set as "we8mswin1252".
get this issue resolved.
Client Tools :: How To Migrate Data From SQL Server To Oracle Database
Jun 13, 2013how to migrate sql server database to oracle database?
View 2 Replies View RelatedWindows / .NET :: Excel VBA Macro To Fetch Data From Oracle Database
Aug 1, 2012we are using ERP System based on Oracle DB. I have an oracle client 10.2.0 installed on my machine (Win 7/64-Bit) and trying to create Excel(2010) VBA-Macro to get datas out of the Oracle DB using a SQL query:
On my old machine (Win XP/Excel 2007) following worked fine:
strConOracle = "Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=TCP)" & _
"(HOST=" & strHost & ")(PORT=1521))" & _
"(CONNECT_DATA=(SERVICE_NAME=" & strDatabase & "))); uid=" & strUser & " ;pwd=" & strPassword & ";"
Set oConOracle = CreateObject("ADODB.Connection")
Set oRsOracle = CreateObject("ADODB.Recordset")
oConOracle.Open strConOracle
Set oRsOracle = oConOracle.Execute(strSQL)
All the datas in the variables coming from cells or userforms - I am 100% sure all this is correct, as as said, it works on any Win XP Machine with Excel 2007
But trying same with Win 7/64-Bit/Excel 2010 gives me following error: MS ODBC Driver for Oracle: ora-01019: unable to allocate memory in the user side.
Data Guard :: Standby Database With Oracle Standard Edition?
Nov 6, 2012my customer wants to create a standby database for his production database (Oracle Standard Edition 11g R2 @ Windows 2008 R2 64 Bit). Now any proof-of-concept which explains shortly the concept and how to achieve it.
View 4 Replies View RelatedPL/SQL :: Oracle Database 11g - Add Partition Based On Amount Of Data To Be Populated
Oct 30, 2013I'm using Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production and TNS for Linux: Version 11.2.0.3.0 - Production.Requirement is to create a script to add a LIST partition to some selected tables in a schema (tables do not have data, they are not partitioned). There are about 300 such tables (can vary) and their names are maintained in a separate table. Example -Existing table
-CREATE TABLE test_part(id number (2),
name varchar2(20),
audit_userid number (9));
Expected table
-CREATE TABLE test_part(id number (2), name varchar2(20), audit_userid number (9))
PARTITION BY LIST (audit_userid) (PARTITION p1_audit_userid VALUES (1));
Ultimate goal is to add more partitions based on the amount of data to be populated.
Oracle Data Changes In Undo Tablespace / Database Buffer Cache
May 30, 2013I have a serious doubt in oracle architecture functionality, when a user issues a update statement the data blocks are carried to db buffer cache and where does the changes to the data blocks are made???? Does a copy of the data block is kept in db buffer cache and the changes are made to the block in buffer cache?? or the a copy of the data block is kept in undo tablespace and changes are made to the blocks in the undo tablespace???
In simple the changes to the data blocks are made at db buffer cache or undo tablespace?
Data Guard :: Oracle 9i - Cannot Mount Database In EXCLUSIVE Mode
Jun 30, 2008I'm trying to create a physical standby database on my Oracle9i DB runing on WinXP.
Note: I have both Primary and Standby on the same system.
Actually everything went well .... I did created the standby DB but the problem is I can not start my primary DB if my standby DB is mounted. I get this error:
ORA-01102: cannot mount database in EXCLUSIVE mode
And when I read about the error message I learnt that I should start my DB in compatible mode ...
Export/Import/SQL Loader :: Copy Data From Oracle Database To Another?
Jun 6, 2013I want to Copy a data from One oracle database to another.
I have checked Import/Export Utility but the problem is import utility doesn't support conflicts resolution techniques between rows.
For Example if there's a table in the source database have the same row key in the destination database. if i use 'Ignore' parameter with value = y, the destination table will have a duplicate rows.
I want to ask if there's another way to import data from oracle database to another with some mechanism of detecting the conflicts and resolve them?
Client Tools :: Export Data From Oracle Database To Excel File?
Aug 21, 2012I am using SQLTools 1.5 for writing Oracle SQL scripts.
I have to import data from excel file to oracle database. How can I do it?
Also how can I export data from Oracle database to Excel file?
Data Guard :: Oracle Application 12.1.1 / Database 10.2.0.4 - Disaster Recovery Site
Aug 18, 2012We have an Oracle application 12.1.1 running with oracle database 10.2.0.4 and we're using HP-UX itanium 11i v3 servers for both application and database, our requirement is to establish a Disaster Recovery site out of our building to ensure data protection.
What is the best option we can use to reduce the cost and to implement the DR site? can we use data guard ? and will be the configurations and requirements for it?
Server Utilities :: How To Load Data In Oracle From Microsoft Access Database (MDB) File
Aug 24, 2012I have one .mdb (Microsoft Access Database) file and it has some tables in it. I had load it once using toad. But now i have to load it frequently into the database. Is it possible using external table, so i can access that tables using "select" statement.
View 6 Replies View RelatedPerformance Tuning :: Tune Data Coming From Legacy System Into Oracle Database
May 22, 2012Customer is sending data from legacy system (Source) with the web service which in turn calls a package lying on Oracle server (Target). Now this package is simply inserting data passed by legacy system into master staging table in Oracle database. When they started this process in Sept 2011 then 4 lack records were inserted into staging table. In Oct 11 it was 0 records Nov 11 it was 2 lack records, Dec 11 it was 1 lack records, in Jan 12 it was 1 lac records, Feb 12 73k records, Mar 12 0 records, Apr 12 52k records.
As we see that number of records inserted in the table got reduced with time.. what should be the starting point here since web service is calling that package on the fly, how can i enable trace for that package? I cannot replicate this is Dev as this process is only working in PROD.
SQL & PL/SQL :: Incorporate Parallel Loading To Load Data Into Database - Oracle Locking Not Working?
Aug 3, 2011At the moment, we were loading the file in our system serially. This is a very old and established system.We would like to incorporate parallel loading for our loaders to load data into the database.
Most of the issues would be due to multiple inserts happening due to the files being loaded in parallel. For some reasons, we cannot give regular commits untill the entire batch of items is processed in case the process needs to rollback. A file can contain different set of batch of items clubbed together for loading.
The issue here is untill the first file finishes loading and commits, the second file would just hang. In fact, mulitiple files might hang for the first file to finish. what can I do to overcome this?I tried to used "lock table t1 in SHARE ROW EXCLUSIVE mode nowait". When the leading process is doing inserts, the failing process will fail with a resource busy and acquire with NOWAIT specified. We would catch this exception and redirect that batch to an error file to be reloaded at a later date.
Server Administration :: Inserting Data To Oracle Database - Shared Memory Realm Does Not Exist
Sep 24, 2013i am continuously inserting data to oracle database after some time like 2 hours oracle disconnects,it creates erros like
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0
after restarting the database with shutdown immediate ans startup if i start inserting records it will show erros like
ORA-01653: unable to extend table SYSTEM.GLT_PROT_TRAFFIC_SUM_VOIP by 8192 in tablespace GLCOMM
but i have created the Tablespace with BigFile Auto Extend and max size unlimited, i am having 400GB disk space created Redo logs with 15gb,i have tried serveral times reinstalling the oracle but problem is not solved.
same problem is happenging with small datafiles also,
operating system: windows server 2008 R2 standard
oracle server : 11g
oracle client : 64 bit
Export/Import/SQL Loader :: Migrating Data From Solid Database To Oracle - Flat Files
Aug 14, 2012I am migrating data from a Solid Database to Oracle, I am using Flat Files to do that.
1.- I download the data to flat files from Solid
2.- I move the files to Oracle server
3.- I upload the data to Oracle
Now, I have done the 90% of the data base, but I have found some tables that has description columns and in this description the users writes enters, so when I try to upload the data to Oracle SQL loader cannot recognize this characters.
Example:
'25','0.','5.','0.','0.','0.','0.','0.','0.','0.','0.','0.','0.','',''
'26','0.','2.','0.','0.','0.','0.','3.','0.','0.','0.','0.','0.','',''
'27','0.','1.','0.','0.','0.','0.','0.','0.','0.','0.','0.','0.','',''
'28','0.','1.','0.','0.','0.','0.','0.','0.','0.','0.','0.','0.','',''
'29','0.','38.','0.','0.','0.','0.','0.','0.','0.','0.','0.','0.','',''
'30','0.','13.','0.','0.','0.','0.','0.','6.','0.','6.','0.','0.','|SE RECHAZA B20CS50SNW ^M
^M
SE RECHAZAN CINCO PZAS ^M
DOS MOD. HSC15I41EH,DOS MOD. HSK15I41EH |Agregó: 06/06/2009 12:22:50
|','DEV. A PROV.'
'31','0.','50.','0.','0.','0.','0.','0.','0.','0.','0.','0.','0.','',''
'32','0.','9.','0.','0.','0.','0.','0.','0.','0.','0.','0.','0.','',''
'33','0.','2.','0.','0.','0.','0.','0.','0.','0.','0.','0.','0.','',''
How can I solve this ?
SQL & PL/SQL :: Move Data From One Data To Another Database Using Database Link
Mar 19, 2010I 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