Oracle 10g

Export to CSV or dump file

can any body guide how to export from command line in oracle 10g tables or db to CSV or dump file.

Moving oracle database

HI, We have planned to move our oracle 10g production database from Solaris to Aix bix. So experts, please suggest any best practices that you follow or any scripts that should be run before moving it or any documentation or case study that will help us to do the work more efficiently. Thanks a...

Oracle 10g on Windows 2003 virtual server

We have installed a SQL server on Windows 2003 virtual server and there were performance issues. Will oracle 10g make a significant difference in terms of performance? Are there known issues concerning 10g DB running on Microsoft 2003 virtual server? thanks

Oracle 8i to Oracle 10g Export /Import

Hi, Presently iam Exporting the Oracle Database of 8i version 8.1.6.0 on HP-UX to import on Oracle 10g 10.2.0.3 So my question is there is any need to apply 8i Patch before taking export i.e; from 8.1.6.0 to 8.1.7.4 this is the last & latest patch of 8i to support 10g so i want to ask you that it...

date problem in oracle 10g

in my oracle 10g server, date is changing by it self some time like in this manner "28-Feb-2008" to "20-Feb-0028". and it will keep interchanging until we restart the server. any budy is having any solution

Oracle listener

Hi all, can you help regarding oracle 10g listener?Sometimes for no reason i cannot log on int database, and then found there is two listeners running at the same time, do you know why?

If I am Exporting Oracle 8i Database to new Oracle10g there is any problem with Oracle block sizes during import

If I am Exporting Oracle 8i Database to new Oracle10g there is any problem with Oracle block sizes during import ? where as Oracle 10g has defaultly 8kb block size and Oracle 8i has 2kb Block size so it can import 8i database to 10g without any problem or we have to create additional 2kb block...

Migration Plan for 9i Linux to 10g Solaris

Does anyone have a migration plan for an Oracle 9i to 10g Migration. Migration will be from Linux running 9i to Solaris running 10g.

Oracle 9i to 10g conversion

have anybody done this type of conversion and what are the problem is can expect, we are using a lot of stored proc and triggers, is there any problem regarding the meta data?

Database problem of Stop working

We are working in Oracle 10g on Linux Debian 32 bit, A week back we had a problem that i was unable to access any tool of oracle in the morning, Everything was fine previously . when i try to write any command server was too slow and when i use sqlplus it is unable to run no reply then i use top...

Advantages/Disadvantages of UNIX vs Windows

Base advantages/disadvantages of UNIX, Linux, and Windows for 10g.

Oracle 10 g OCA question dumps

Hi i am planning to write the 10g OCA certification Exam , can anybody pls send the dumps , thanks

Oracle 10g Enterprise Manager Console - Sort Schema list

I have recently upgraded to Oracle 10g Enterprise Manager Console (without Web connection), and have found that my schema list in the enterprise manager console is no longer in alphabetical order. I cannot find any information on how to fix this. In the previous Oracle version, the list was...

Connecting oracle forms 6i with 10g XE database

I would like to know from anyone out there how to cnfigure an oracle client with developer 6i to communicate with server with oracle 10g XE.

how to store information in variables accessible to procedures in the packages??

how do i store information in variables which are accesible by more than one procedures in the same package?? (i.e. i want to take input information using a procedure and i want to call other procedures internally which will use these input information to give results...) CAN ANYONE HELPME ON...

Problem in oracle 10G form

I want to add a picture in oracle 10G form by clicking button or image item and then want to save it in data base using long raw data type. Please tell me how can I add it.

Oracle Patch

Oracle Patch p4898608_10203_GENERIC to AIX and p6079591_10203_AIX64-5L. I have already apply the patch p5337014_10203_AIX64-5L. Shall I follow the same procedure to apply the above 2 patches. I have not been given proper document to apply the above 2 patches by my previous people. Please...

10 g Temp Tablespace always shows full in OEM.

have a Oracle 10g database that is with its temporary tablespace full. Is there any way to clean this tablespace? I tried to restart the database, but i've no effect.Every day I increase the size of temp tablespace.Night we run some procedures and morning temp tablespace shows Full.

Temp Tablespace in 10G

have a Oracle 10g database that is with its temporary tablespace full. Is there any way to clean this tablespace? I tried to restart the database, but i've no effect

Oracle froms n Reports installation error

Hi All, I am trying to install oracle 10g form & Report on HP unix 11.11 I am getting following error. Starting Oracle Universal Installer ... Checking requirements... Checking operating system version: must be B.11.11 or B.11.00. Actual B.11.11 Passed ...