I am new to Oracle DBA activities. I am using Oracle 10g database. Due to space constraint I dropped all the objects (not the user) which was imported by me earlier. But still i didn't find an...
Within the last month trc files in the Oracle bdump directory have been growing like crazy. Each of them bear a size ranging from 3 Mb to 100 MB and everyday they seem to be taking up 800 mb t...
How do I correct export just the ORACLE Schema ?
I am running an upgrade from Ora8i to Oracle 10G, need the correct syntax;
Here is what I have been using;
exp userid=system/******** fi...
Hi,
I need to import/convert the provided XML file into Oracle 10g. I am looking for the most efficient means to accomplish this. Note I had to change the extension to .txt for upload pur...
Hello All,
I need to create a text file to feed another application. The stored procedure pulls the data from an oracle View. The first line is static, the second line contains the period a...
Hi Experts,
I need to restore 4 tables for our oracle database. I have got a export dump file of the whole database backup. Can you please tell me how can i restore those 4 tables from the ...
Can someone please correct the syntax below? Oracle's SQL Worksheet does not like it....
begin transaction;
update emrcontent.page_images
set emrcontent.page_images.path = '\\OCH52523...
Hi,
I recently moved a C# web service from a dev machine to a production machine. The web service uses a back end Oracle 10g database on the dev machine and production machine. I cop...
I am a newbie to Oracle. I however have extensive experience in Sql Sever. I have a newly installed instance of Oracle 10g and received a .dmp file from a client. It is a default install of th...
I have two tables I have to set extents for - I am doing this as I am still a beginner. I have on table with 500 hundred rows, and I calcualted that the average row size is 30 bytes, cloumns...
Hi,
I have two queries, these are related so posting one question
Query 1
We are doing migration of huge data in Oracle 10g.
Some of the tables contain a huge data e.g. 7 million recor...
Hello,
I have installed Oracle 10g on RHEL 4 succesfully. After installing the database starts normally.
But the problem I am having is I get the following error when I try to execute ...
Hello,
If I look at the following (Oracle 10gR2) I see that
SQL> select tablespace_name, extent_management, allocation_type,
segment_space_management from dba_tablespaces;
TABLESPACE...
I have a view called VW_PH_INTERFACE created which includes the following column:
DATE_TIME_OF_ANALYSIS VARCHAR2(1024)
This column contains dates in the format - DD.MM.YYYY HH24:MI (Exam...
i want to generate Excel output from oracle Reports. Seems oracle Doesn't support Excel reports. Is there any way to achieve this functionality?
Hi expert,
I have the dataset which contains datatime formated as 12/06/2008 12:00:00, I need to reformat it as 12-June-2008 to store into ORACLE database, otherwise it give me error as OR...
Hi,
I have a rman script and it works... unless i try calling it from a shell script through cron...then it doesn't!
Ok, i have a shell script called rmanbackup (located in /usr/local/bi...
We have a cursor that selects 1 field (ID) and then runs a complex insert statement where it inserts that ID along with other information from a more complex SELECT.
If we limit the number ...
Hello
A client of mine uses a bespoke piece of software, based on Oracle 10g, which generates output using Oracle Forms rwservlet.
The 10g PDFs are generated seemingly very slowly (perha...
I have renamed my test/practice Oracle database, to the name of my production database. I also need to change the dbid of my test database to be same as the production database, so as not to ...
I have daily/weekly/monthly reports to generate in pdf format.
Currently they are being run via Report Builder 10.1.2.0.2
These reports have 2 User Parameters for dates (START_DATE, END_DATE...
Please give me a quick guide what steps I need to configure Dataguard.
There is an existing database and I need to configure a new node as standby.
For instance:
What are my first steps...
I have a oracle db running on a linux maching. Now, I need to access the db from my windows XP machine. I downloaded and unzipped the oracle instant client on my windows machine. I added the ...
I am interfacing to both SQL Server and Oracle through a thrid party database web service.
If I submit a SQL query such as "select * from employee", multiple rows are returned from both SQL...
We currently have one oracle home for each database instance as a company standard because it facilitates database upgrades and emc disk replication. Not all database instances are upgraded ...
