Hi all, I have to drop a USER and I need to retrieve all the grants I gave to that user. I tried querying USER_TAB_PRIVS but I saw something missing such as grant on external table or on creating synonym. Anyone can give me an hint on how to retrieve the complete list of a grants? I mean grants on object, table and other kind of reso...
Hi, I am trying to install Oracle 11g client on my box that currently has Oracle 9i installed. I keep getting this error when I click NEXT as the wizard starts: OUI-10037:Unable to set up inventory. You may not have the proper permissions Since I am logged in as a local Admin, this doesn't make much sense. The ONLY thing I've found on...
We have an Oracle Enterprise database in production and another instance that we use as both a QA and Development database. QA has requested that they be given separate schemas within the database so they can test applications isolated from changes made by developers. For an example, say the schema used in development and the one that ...
I have a SQL Server Reporting Server R2 installed on a Windows 2008 R2 machine. I want to store and run a report that selects its data from an Oracle 11g server. I have installed ODTwithODAC112012 on the windows machine where the report server is installed. Using report Builder 3.0, on the report server itself, I can select the oracle d...
Is there an official matrix that clearly explain how export dump format done with a specific version, is or not compatible with all others? I mean to fill this grid: Exp done with version: | 7 | 8i | 9i | 10g | 11g Is compatible with Imp 7 |yes | no | no | no | no 8i|yes |yes | no | no | no ...
Hi, i am trying to fetch an id from an oracle table. Its something like "TN0001234567890345". What i want is to sort the values according to the right most 10 positions. I am using oracle 11g. Is there any funcrion to cut the rightmost 10 places in oracle ? thanks in advance tismon ...
I'm trying to use an old laptop (Win2000 P3 1.1Ghz 256MB ram) as an oracle database server for a small group project of 3/6 people on my college. I don't need much, just some databases with 2 accounts, 10/15 tables, some views and triggers, however even the simplest database requires 1GB of physical ram (2GB of swap) and the installer re...
I have two files WSDL file and Deployment plan file. I am trying to replace an attribute at the WSDL file from the Deployment plan file. WSDL file <wsdl:definitions name="Project" targetNameSpace="http://xxx/yyy/project" xmlns:ns0="http://xxx/zzz"> <wsdl:types> <xs:schema> ..... </sx:schema> </w...
Currently I'm using the ojdbc14.jar Oracle 10g thin driver to access an Oracle 10g database. I would like to upgrade the driver to the thin ojdbc6.jar Oracle 11g driver ahead of the actual upgrade of the DB server occurs. Using an 11g driver against the 10g DB seems fine in testing so far, but I'm wondering if anyone can confirm this O...
Hi, I'm experiencing some performance problem on a Oracle DB hosted by a virtual server. Is there any tool for benchmark of Oracle DB or for gathering information about performance? Thanks, Andrea ...
i'm trying to install oracle 11g database in my ubuntu 10.10, following this tutorial http://oracleabc.com/b/archives/167 but, at the step 11, the system asks for oracle password! which password is it? i did not set anything yet! i've tried 'oracle', 'password', , (my system's) root password, but doesn't work! are there some 'default pa...
Hi, I have a need to install Oracle 11g R2 on Windows Server 2008 R2. I have downloaded the two files from Oracle (win64_11gR2_database) and the client (win64_11gR2_client). Does anyone have a guide or step by step to sucessfully setup Oracle? My goal is to connect to the database from Visual Studio 2010. Thanks ...
I have the following data set, which represents nodes in a directed graph. CREATE TABLE nodes (NODE_FROM VARCHAR2(10), NODE_TO VARCHAR2(10)); INSERT INTO nodes VALUES('GT','TG'); INSERT INTO nodes VALUES('GG','GC'); INSERT INTO nodes VALUES('AT','TG'); INSERT INTO nodes VALUES('TG','GC'); INSERT INTO nodes VALUES('G...
I have a field in my database where users have saved free-form telephone numbers. As a result, the data has all sorts of different formatting: (area) nnn-nnnn, area-nnn-nnnn, area.nnn.nnnn, etc. I would like to strip out all the non-numeric characters and just store the digits, but I can't find a simple way to do this. Is it possible...
Ok, I have a complex recursion problem. I want to get a dependecy installation sequence of all of my objcts (all_objects table) in my Oracle 11g database. First I have created a view holding all dependencies create or replace view REALLY_ALL_DEPENDENCIES as select * from ALL_DEPENDENCIES union select owner, index_name, 'INDEX', ta...
I have developed a C# 3.5 Mvc 1.0 application using oracle 11gR2 client which uses odp .net 2.112.1.0. I want to deploy it in my IIS7 server which has oracle client 10g which uses odp.net 2.102.2.20 . I am getting the following error Could not load file or assembly 'Oracle.DataAccess, Version=2.112.1.0, Culture=neutral, PublicK...
i am trying to delete a record from one table in my db , but the table has forign keys to another table in mu db , so i want to make on delete cascade using sql developr in oracle 11g , how can i make it? ...
Hi! I am trying to connect to oracle db without full installation of oracle client done on the machine. I found this helpfull post Using the new ODP.Net to access Oracle from C# with simple deployment but when I try it, I am failed on the next exception: [Oracle.DataAccess.Client.OracleException ORA-12737: Instant Client Light: unsupp...
I have built a "best guess" query to get the related table.column for a sequence. Is there a better, cleaner method to get this relation? select ut.table_name, ut.table_owner, ut.trigger_name, us.sequence_name ,upper(dbms_metadata.get_ddl('TRIGGER', ut.trigger_name, ut.table_owner )) triger_ddl ,to_char(regexp_substr( upper(d...
I created a package and a package body as below: Create or replace Package pkg_1 as procedure main(param1 varchar2, param2 varchar2, param3 int); procedure one(param1 varchar2, param2 varchar2); procedure two(param1 varchar2, param2 varchar2); end pkg_1; / create or replace package body pkg_1 as procedure main (param1 varchar2, param2 ...