hi
i can open all the packages in sql developer and now i am trying to use toad. when i connected to the database and tried to open the package everytime for i get some error like 'IN' not a ...
Could we make it small size SQL???
insert into condition_res_api (success_flg,category1,npa_credit,case_count)
(SELECT 'Y'
,'S'
,'TACL'
,COUNT (1) total_acl_count
FROM nbfc_cus...
I executed a script to delete a tablespace and associated users from an Oracle database.
However, although the tablespace has beeen dropped, the user sessions still remain. The user is sti...
We have a very simple need and have received a lot of conflictig advise. The simple question is "How do I remove a CR or LF out of one column contained in a CSV text INFILE?" I want to do t...
Hi, everybody.
Oracle Database Control 10g (MS Window Server 2003) displays on the home page the following message
-- java.lang.Exception: IOException is sending Request :: Connection ref...
As I wanted to connect sqlserver 2000 from Oracle 10g, I followed all the required steps.
1.Configured / tested Sqlserver ODBC( orasql)
2.made a new listener by
a.Creating initorasql fil...
We are having windows 2003 server that is installed with oracle 10g.
The problem is related to alertlog file.
The file has grown too large (more then 1GB). I just want to control size of a...
Hi Experts,
I am trying to setup Oracle 10g dataguard on solaris 10 boxes. Here is the config file and tnsnames for primary and standby i have used.
primary database:
############
init...
Hello Experts,
Can I have full outer join on multiple tables:
create view test_con_fore_upp_v as
select a.qtr,a.su_fig,a.tir,b.capa,c.up_lim from
hist_con_ti_f_mv a full outer join hist...
I have two instances on Oracle 10G on the same server.
Only one of them completely starts when the server boots up.
The OS is Windows 2003 Server.
The DBConsole is fine for the last instan...
Hi,
We are planning to use RMAN as our basic backup tool to backup Oracle database.We are using ASM to store data files, control files and archivelogs. We tested various scenarios except on...
10gR2 in windows 2003 Enterprise. today I find the following lo in summitdb_mman_684.trcg:
AUTO SGA: Not free 0x96FD8D0C, 1, 1, 1
AUTO SGA: Not free 0x96FD8E84, 1, 1, 1
AUTO SGA: Not fr...
I recently issued a RECOVER DATABASE UNTIL TIME command and it executed successfully. Now two hours later I am still getting the following error when trying to connect:
Ora-01033 Initializat...
Is there a way to merge two or more cursors together into a single cursor in Oracle 10g PL/SQL?
I have multiple cursors that contain thousands of records. Each cursor has an ID that ties t...
Please take a look at my .profile
/**** .profile *******/
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.:/usr/local/ ...
I have Oracle 10g and I'm trying to write a query to return information in a cell as a column name:
Name ID Type
David AB3 Cat
Daniel 3CD ...
I have a Dell Server running RedHat Linux, which was connected to a SCSI Disk Array containing 12 disks configured as 6 Logical RAID 1 Partitions. Unfortunatly the disk array chassis seems to ...
hai
i am facing one problem to set oracle home to existing $PATH. I am doing like this
export PATH=$PATH:/opt/mis/oracle/product/10.2.0
my actual $PATH VALUE IS
echo $PATH
/usr/c...
Hi,
I am trying to configure Enterprise Manager via command prompt since it failed while creating the database through DBCA. I have a two node cluster running oracle 10g (10.2.0.2) on Windo...
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...
The documentation for the imp utility states that although there are no parameters to change the tablespace from the export to the import, you can coerce the utility to place things in a parti...
I want to update a field for many records from an Excel Spreadsheet. The number of recs is >1000 and a once off thing. I thought to generate these update statements in the spread sheet and pas...
I am using an Oracle sqlplus script to run reports and I need to have the spooled text file output open notepad or wordpad in windows when the script is complete so the report can be viewed an...
Hi experts,
Some information about my Database
OS : Sun 10
Database: Oracle 10.2.0.1.0
Mode : Real application cluster
I have problem with startup of dbconsole , so I decide to recreat...
Hi Friends
I am trying to setup tnsnames and listener. But for some reason it is not getting connected to database and it throws error.
ORA-12514: TNS:listener does not currently
Can ...
