Search results for query: *

Hi, We are using Oracle 10g. We want to implement certain security setup for the schemas to be accessed by the developers. The design is as follows: MAIN_MGR:- will hold the complete tables, data and stored procedures ACCESS_MGR:- will have the synonyms to the tables created in MAIN_MGR and...

Hi, It has been planned in our project to migrate from oracle 8i to 10g. The installation and server upgradation will be taken care by a seperate team. We need to deploy the complete set of tables, data and stored procedures in 10g. Is it possible to take simple export & import the data in...

Hi, Would require help in transposing row values to single column values The below query provides the list of indexes and the index columns. In case of composite indexes, multiple index column is appearing in seperate rows. select a.INDEX_NAME, b. column_name from all_indexes a...

Hi, I am new to BO & Analytics tools, and having problem in displaying the dates in sorted order in the dashboard. The dashboard is a trend chart, which picks up data from an QUAS query. The QUAS query has an BO universe object with timestamp column in it formatted to display as DD-MON...

Hi, The data residing in a particular table is of the following format: ROW_VALUE FIELD_VALUE ------------- -------------------- 1 1 1 BCKUP 2 13 2 BUSER 3 4 3 AUSER 4 36 4 CUB 5 7...

Hi, My requirement is to collect metrics from database/ datawarehouse environment and publish it. A master table with the below structure will hold the required information: Metrics Master ============== Metrics Id Metrics Name Query The query will contain the select query which would be...

Hi, I am facing problems in populating the data from a BLOB field to a CLOB field. Could somebody help in this regards. Shantha. Talent is what you possess; genius is what possesses you

Hi, I am getting Exception in thread &quot;main&quot; java.lang.OutOfMemoryError <<no stack trace available>> while running an xsql from the command line mode. I am using Apache/Jserv on Solaris. I also tried increasing the heap size in jserv.properties by setting # The Java Virtual Machine...

I need to replace field in one file with field in another file. File 1 111-000001 111-111111 222-222323 232-343333 File 2 111-000001,AER 111-111111,EXE 111-111111,AER 111-111111,EXE 222-222323,AER 232-343333,AER If you note file 1 - field 1 has same values as file2 field1 but in the place...

Hai, I need to perform wget against my webserver. Whenever I say wget &quot;http://<ip-address//path it gives the following response: Connecting to <ip address>... connected! HTTP request sent, awaiting response... 404 Not Found 09:39:19 ERROR 404: Not Found. I am using Apache web...

Hai, I need a script to monitor my webserver where I have to find whether any of the child process is hanging and doesnot close out the session. Thanks & Regards, Shanthalakshmi.