folks
how do i convert lets say 4-2-7 -(4 February 2007) to show the week number of the current year
i.e
week6
I am looking for the OJVM patch and opatch for 9.2.0.4. It is not on Metalink.
Anyone know what patch set for this verion the OPATCh would be in?
any ideas?
Hi,
using Oracle 9.0.
In our application we are using a lot of nested select statements in order to get a set of items for paging in the front en. For example in the sql below we are se...
folks
i am trying to run an update statemtn thru sql plus
UPDATE PO SET PROJECTID ='B6999' WHERE PONUM ='1080';
calling from a file
@C:\sql\TEST.SQL;
but the record doesnt commi...
What are the possible causes of ORA-2100 errors? I have a long piece of PRO*C code with many cursors and this error happens during the execution of one of the exec sql select statements. Ive l...
I want to explore the built-in auditing features of oracle.
Is it correct to assume the first thing you do is set AUDIT_TRAIL=DB and then I can run the AUDIT command on users/tables etc to se...
I have several tables, each with a CREATED_DATE field. I select from all these tables in a view, however I want to return the most recent CREATED_DATE value from all the tables?
So if the f...
Hi
I'm looking for the best, most appropriate and secure method for copying table data from one oracle database into a separate oracle database. we're currently considering using exp/imp but ...
# SQLNET.ORA
# Generated by Oracle configuration tools.
#NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
#NAMES.DIRECTORY_PATH= (LDAP)
NAMES.DIRECTORY_PATH= (TNSNAMES)
#NAMES.DI...
Can you provide steps on how to refresh development database using a full export of production? Thanks.
Oracle 9i on AIX 5.2
After running installation of Oracle how do I verify that it is up and running? I have not created the first database yet. Is there a shell script I can run on the server?
Oracle 9i on AIX 5.2
Hi experts,
I have a web page developed with .Net 2.0 connected to an oracle 9i database. I am using the gidview control in order to select, update, delete records. The asp page correc...
Hi experts
this sentence has any improvement?
t = 10.360 sec
Thanks
Jair Duran
How do I create a maintenance plan in oracle for index rebuild and update stats? do I need to create it with a cron job? beside these, do we need any other dba maintenance plan which should ru...
Hello
I have a pls block as follows:
DECLARE
CURSOR cGetTableName
IS
SELECT table_owner,
table_name,
partition_name
FROM dba_data_files
WHERE table_owner IN ('HMPDEV','DW'DEV'); ...
What are the pros and cons of cold and hot backup other than having the db offline and online.
thx much
Hi all,
I have a question with Oracle SQLLDR. I have a table, which has the following columns
SQL> desc HARRIS.CUST;
Name Null? ...
I am trying to figure out how to implement PKI on a database server. Is anyone familiar with PKI that could provide step by step process and documentation?
Hi folks,
I'm creating a partitioned table which will hold millions of records in different paritions based on years, from 1998 to 2010.
I know that that partitions will help me reduce t...
I want to generate Oracle report in Internet explorer, In report builder when I click Generate To Web Browser, it generates the report in browser but when I call that report from Oracle Forms ...
hi
i have stuck with this for quite a number of days
we have a vb.net application which connects to an oracle database,
now i want to do the following commands executed currently via ba...
I made few changes in the initial query to replace the inner queries with funtion compl.test_compl (dan2.documentid) as below to avoid the costly sorting.
Initial query:
SELECT dan4.do...
i need to access and read some text file located on a server different from that where my database is located. i need to read the data from these files to load them in table in my database. fo...
I have Oracle 9.2 installed on a server. I can see few services running and I want to know what is their role. Which services I can turn off? At present no projects are going on and I am learn...
I use Windows XP. If I select the Control Panel , and then select "Administrative Tools", and then select "Services", I can find - between the others - the following Oracle services:
1) Or...
