Transfer Data To SQL Server 2008 / Arabic Data Showing

Jan 15, 2013

I am trying to transfer data from Oracle database table into another table resides in a SQL server 2008. A database link is already set, and data can be selected/queried using

select * from a_table@db_link

the thing is when trying to insert Arabic data from Oracle to a SQL server table

insert into a_table@db_link values(
'N''some data in Arabic'' ,
'11-oct-00',
'some data in English'
);
commit;

its inserted alright, but when we try to display the data it shows like this instead of displaying Arabic, the english data is alright, but also date show as garbage?!!

when trying to insert arabic data directly through SQL server its fine though.I suggested that we transfer data through ODBC to flat files like Acess and then to SQL server but the team rejected it since they're going to do it daily and the data is huge( we are talking more than 28000 records).

View 1 Replies


ADVERTISEMENT

SQL & PL/SQL :: Transfer Data - Arabic Language Column Appears As Junk

Feb 8, 2012

When I transfer the data from Oracle to MS SQL I have one column in a table which is of Arabic Language.The data is fine in Oracle but when I transfer it to MS SQL Server I see that the text in MS SQL server appears as junk.

View 1 Replies View Related

Transfer Data From Sql Server To EBS?

Jun 28, 2012

I need to transfer data from Mirco Soft SQL server to Oracle data base (EBS).

View 3 Replies View Related

Data Guard :: Logical Standby On Windows Server 2008

Sep 8, 2010

Can i create logical_stand_by for windows server 2008, the primary data base is HP UX , both operating systems are 64 bits and data bases are Oracle 10g 10.2.0.1.0.

View 6 Replies View Related

SQL & PL/SQL :: Converting Data From English To Arabic?

Feb 1, 2012

I need to prepare a bilingual system (English and Arabic).

So i need to store data in English as well as in Arabic

Is there any possibility to convert the data from English to Arabic and Arabic to English through oracle forms

basically what i am thinking is let us suppose user selected the English version of the application and he entered all the data in English during saving the records i need to convert all the English data into Arabic and store it in another table for Arabic data reference.

View 3 Replies View Related

Forms :: To Excel Data Transfer

Apr 8, 2010

I found another way to transfer the data from forms to excel apart from doing it through ole2 or client. So thought of sharing it with all...

Here it goes:-

declare
ifile client_text_io.file_type;
temp varchar2(1000);
Cursor c1 is select ename, job from emp;

[Code]....

Attach webutil to form and just paste the code on a button and log on to scott. The excel file will be created in c: drive with name test.

View 5 Replies View Related

Replication :: Data Transfer From Oracle 10g To 9i

Feb 16, 2011

We need to transfer data from oracle 10g to Oracle 9i in the following condition.

There will be two database server , one is online server where online user fill the form which is generated by java, spring , hibernate and using database 10 g. at day end i need to execute a process that transferring data from online server to offline server that is in oracle database 9i. This process is scheduled. Some security reason client do not kept this two database on same network. My challenge is that transfer data from online server to offline server with applying client security norms.I have option like:

1) Using Oracle replication method, creating materialized view on remote server , refreshing it at regular interval. but database connectivity is not contineous, should i go for that ?

2) Write java application on intermediate server where we write process to get the connection of this two database servers. From java application we call the procedure for selecting data from Oracle 10g and insert into oracle 9i database and using flag on both data to identified how many rows are transfered and how many remaining for trasfer.

View 7 Replies View Related

SQL & PL/SQL :: Transfer Data On Uneven Tables

Jan 13, 2011

I'm having problems transferring data from one table to another as as one table as only 2 fields and the one data meant to go to has id which i just want to increment value because its primary key

table bill fields (name, age)Values (gate,85)

table oracle (pl_id, pl_name, pl_age) often wont insert cz data too short

this how i tried and failed

INSERT INTO oracle (TIME_ID) VALUES(SEQ_CUST.NEXTVAL)
(SELECT name, age FROM gates WHERE name = 'gates');

also tried

SQL> SELECT SEQ_CUST.CURRVAL FROM DUAL;
SELECT seq_cust.currval FROM dual;
*
ORA-08002: sequence SEQ_CUST.CURRVAL IS NOT yet defined IN this session

SQL> SELECT SEQ_CUST.NEXTVAL FROM DUAL;
1
SQL> SELECT SEQ_CUST.CURRVAL FROM DUAL;
1
INSERT INTO gate (TIME_ID) VALUES(SEQ_CUST.NEXTVAL)
(SELECT age, name FROM CRIME_ACTIVITY WHERE ID = '1');

or have both tables with

View 2 Replies View Related

SQL & PL/SQL :: Data Transfer From Fact To History Table?

Aug 9, 2010

I need to transfer 6 million records from fact tables to history table .. What is the better and fast process to do that.

View 3 Replies View Related

Client Tools :: How To Transfer Data From Sql To Oracle

Jan 18, 2011

want to transfer data from sql to oracle having same structure in both database.

View 3 Replies View Related

Backup & Recovery :: Transfer Database From Windows 2003 32 Bit To Windows 2008 64 Bit

Mar 30, 2011

I want to Transfer Oracle Database 11g Release 11.1.0.7.0 on windows 2003 32 bit server to Windows 2008 server 64 bit I have Cold RMAN backup. and directory structure of both server are same Do i need to do anything to change datafile to 64 bit or do i need to apply any change to any object

View 6 Replies View Related

Forms :: Transfer Data From Oracle 9i To Serial Port?

Feb 14, 2012

I want to transfer data from Oracle form 9i to serial port.

Serial port is connected to electric board to show.

View 2 Replies View Related

JDeveloper, Java & XML :: Two Separate Database - Transfer Data

Feb 15, 2011

I have two separate databases, I want to send XML file contains a query from one to the other , that read query and return results to a first via XML file.

View 10 Replies View Related

Data Guard :: Transfer Of Archive Log On Standby Database

Dec 9, 2010

I successfully created the standby database and the archive logs were properly moving on both the primary and the standby databases. For the proper transfer of the archive logs on the STANDBY database I used "FAL_CLIENT AND FAL_SERVER" in the pfile of the primary database specifying the location of the primary and the Standby respectively.

When I removed both the parameters from the pfile of the primary database still there was the transfer of the archive logs however there should not be "If I am not wrong" as I have removed both the parameters.

why there is still the transfer of the archive logs on the standby database.

View 3 Replies View Related

SQL & PL/SQL :: Showing Monthly Data

Mar 6, 2013

I am having the query

SELECT JOB,
decode(to_char(hiredate,'YY'),80,to_char(hiredate,'MON'),NULL) "80",
decode(to_char(hiredate,'YY'),81,to_char(hiredate,'MON'),NULL) "81",
decode(to_char(hiredate,'YY'),82,to_char(hiredate,'MON'),NULL) "82",
decode(to_char(hiredate,'YY'),83,to_char(hiredate,'MON'),NULL) "83",
count(*) total
FROM emp
WHERE JOB='CLERK'
GROUP BY JOB,
hiredate;

I want result as follows

job 80 81 82 83 TOTAL
CLERK DEC DEC 2
CLERK JAN JAN 2

That means if 80,81,82,83 if having some common month then it should show side by side.

View 20 Replies View Related

Data Guard :: How To Transfer Redo Log Files To Standby Database

May 29, 2010

How to transfer redo log files to standby database..

View 1 Replies View Related

Data Guard :: Transfer Archived Log Files To Standby Database

Oct 8, 2011

1> Does dataguard in 10g use ftp/rsh to transfer archived log files to standby database or some other protocol?

2> In my primary database, archives are getting generated normally, there is no error in alert log file. But archives are not getting transferred to standby database. I am able to connect through sys user from primary server to standby database & vice versa.

Also, tnsping is working fine.

All was working fine till 2 days back & no parameter has been changed from database side. I am not able to transfer the file manually through FTP to standby server. Does it is the problem? Or dataguard doesnt use FTP protocol to transfer the files?

View 2 Replies View Related

Data Guard :: Unable To Transfer Archivelog Wrong Pass File

Aug 2, 2010

I am creating physical standby database through Rman duplicate command from 2 node rac cluster. rman do all its work. now am try to start the mrp process on physical standby database. I am getting following errors

------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
ORA-16191: Primary log shipping client not logged on standby
------------------------------------------------------------

I copied the same pass file from primary to standby and many times verify the same but i got the same error.

View 4 Replies View Related

Reports & Discoverer :: View Not Showing All Data?

Nov 1, 2011

We have a view that shows the all the data that we expect, so we created a report to show that data, the report worked, then all of a sudden the report stopped showing all the data. (we did have a server move)I checked the view and the all the data is there....

I have created a new report based on the view but it does the same thing, it doesn't bring all the data up (i get very old data), there are no conditions or anything.

other tables and views seem fine. i have recreated the view and i still have the same problem.

View 2 Replies View Related

Data Guard :: Setup - New Installation Of 11GR2 / OS Windows 2008 R2

Jun 8, 2011

We are planning to have new installation of 11GR2 and would like to create data guard for this system. I have one server in Houston and other in Austin TX. the OS will be Windows 2008 R2.

How can i set up data guard and what is the requirements?

View 2 Replies View Related

Forms :: Multiline Data / Showing In One Text Field

Mar 1, 2011

I have got data in a table like

ID Service
1 A
1 B
1 C

I have written a cursor which is fetching it like A,B,C and assigning it in a display field.

It is working fine.

I want to display it in single text field but in multiple lines.i have set the property multiline to yes in property insepector.

I want to display it like

A
B
C

but it should remain in single field/text box. Infact i am unable to break the line in cursor.

View 2 Replies View Related

Forms :: Data Between Dates But Parameter Not Working And Showing All?

May 4, 2011

i am seting runtime where clause on Forms as follow:

set_block_property('FORMC', onetime_where,'where to_char(INVOICE_DATE,'||'DD-MON-YYYY'||') >='||'to_date('||:search.inv_frm||','||'DD-MON-YYYY'||')'||
' and to_char(INVOICE_DATE,'||'DD-MON-YYYY'||') <' || 'to_date('||:search.inv_to||','||'DD-MON-YYYY'||')');

:search.inv_from is from date
:search.inv_to is up to date

i wann data between this dates but date parameter is not working it showing all data...... where synatx get wrong..

View 11 Replies View Related

Client Tools :: DBMS-PROFILER Not Showing Any Data?

Nov 29, 2010

I am using Oracle 10G with Toad & want to use DBMS_PROFILER to identify which part of procedure is taking long time.

I created PLSQL_PROFILER_RUNS,PLSQL_PROFILER_UNITS,PLSQL_PROFILER_DATA tables. and I am running DBMS_PROFILER as below.

DECLARE
x INTEGER;
BEGIN
x := DBMS_PROFILER.start_profiler ('Test Profiler');

[code]...

The procedure run is successfully completed.I gave the following command to see the data,

SELECT runid, run_date, run_total_time, run_comment
FROM plsql_profiler_runs;
SELECT runid, unit_number, unit_type, unit_owner, unit_name, unit_timestamp,
total_time
FROM plsql_profiler_units
SELECT runid, unit_number, line#, total_occur, total_time, min_time, max_time
FROM plsql_profiler_data

No data is displayed. Then I created these tables in SYS and gave grant to public.Yet It's same. No data is coming into the tables.

View 5 Replies View Related

Reports & Discoverer :: Showing The Number Sequence Of Displayed Data

Oct 21, 2010

I have query in that query i should display the number of row. I have tried to select the row num but when i use it the data will be duplicated. I have found something that related to use temporary table, or subquery but all of them will not work because the query depends on many tables and if i use temporary table filling the table and then reading from it will take too long time.

View 11 Replies View Related

Forms :: Data Entering Form Not Showing Any ERROR Messages / SAVE RECORD Message

Jan 15, 2013

I developed a form in forms9i, at the time of data entering form is not showing any ERROR messages or SAVE RECORD message and when I press exit button it is asking "DO YOU WANT TO SAVE THE CHANGES YOU HAVE MADE".

I have checked my PRIMARY KEY field and there is no mistake and value is populating at PRE INSERT.

View 2 Replies View Related

Server Utilities :: Transferring Changed Data From Database A To B By Data Pump?

Apr 1, 2011

I have database A (Working in Live environment) and Database B copy of Database (Not live) I have Restored whole database (A) RMAN backup file on Database (B) Previous week now i don't want to change anything in any schema and want to import only updated and new records in the table in Database B

There are around 20 schema If for example i have everything in new database B all required database objects like Procedure,functions, packages with indexes in all tables and data in tables, i just want to add new data and updated data.

IF i do following in source database

expdp directory=dpump_dir dumpfile=table_data.dmp content=data_only schemas=ACCMAIN,HRMAIN,..... include=TABLE

AND Import in destination database B, will it add new data and update existing one in table and not touch the table structure and indexes.

View 5 Replies View Related

Server Utilities :: Data Pump For Exporting And Importing Extremely Large Data Files

Sep 24, 2010

I am considering all of the capabilities and benefits of using Data Pump for exporting and importing extremely large data files. Would like to know if importing to tape is possible? If so, would the data be accessible if needed later?

View 4 Replies View Related

Server Administration :: Restoring The Oracle Services In Windows 2008 Server

Jun 27, 2012

I was trying to delete the database in the test server. When i was deleting listener was already stopped, i continued deleting using dbca, it shown me some alert that datafiles cant be deleted because system could't find database, since listner was stopped so only service was deleted(the one showing in the windows administrator toolsservicesOracleServiceTEST).

All the datafile parameter files are still there. How can i delete the datafiles and parameter files belongs to that database or how to create the deleted service, so that i will start the listener and do the complete deleting of the database.

View 3 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

Server Administration :: Oracle 11g R2 Installation On Windows 2008 64 Bit Server

Apr 19, 2011

I want to install Oracle 11g R2 in windows 2008 64 bit server. How can I know whether my server is ready to install Oracle ie is all components are available in server or any patch is to be applied etc.

View 3 Replies View Related







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