We're trying to identify the locations of certain information stored across our enterprise in order to bring it into compliance with our data policies. On the file end, we're using Nessus to search through differing files, but I'm wondering about on the database end. Using Nessus would seem largely pointless because it would output the...
I have input data coming from a flat file which has english, japanese, chinese characters in one column. I am loading these values in a staging table column whose schema definition is VARCHAR2(250 CHAR), the main table column has definition VARCHAR2(250) WHICH i can not change. So, i am doing a SUBSTR on this column. After loading the t...
Hi, I have 2 components as below 1) a windows service that reads DLL path, properties and functions from a config file and executes the function of the DLL using reflections.Assemply --- It works perfectly fine with any DLL (without DB connection). Idea is to create a windows service which will perform any task specified in the config ...
how can i detect that a column in oracle database has chinese (multibyte) characters in it. ...
I am working with oracle and nhibernate. I can select list of an object from db table (all items in table) as Iquerable, but when I try to select an item from the list using "linq where clause" it sends nonsense query to oracle db. And it gets invalid identifier error. I can get whole list without any error in query, it happens when I u...
Hi, I am looking for a tool to monitor results of a periodically run sql query and raise a notification based on the fact that the query returns any results. (any other filters are welcome) I need to watch a transaction table for errors, and it would be great if my sql query could run in background, refresh itself periodically and show...
There is an Oracle DB to which I have access. I can view its packages using Aqua Data Studio and make queries to it. I don't have any access to the filesystem of the server. There is also a binary that uses that database by calling stored procedures from it. I want to know which stored procedures and with what parameters are used by th...
In previous question I got comment about Oracle statistics: Oracle doesn't know that 50M is greater than the number of rows. Sure, it has statistics, but they could be old and wrong - and Oracle would never allow itself to deliver an incorrect result only because the statistics are wrong I was pretty sure that Oracle relies on stat...
I have a database "TEST", to which I connect at address 123.45.67.89:1521. How do I connect to it using PL/SQL Developer? ...
I have a large table that is replicated from Oracle 10.2.0.4 to and Oracle 9i database using MView replication over the network. The master table is about 50GB, 160M rows and there are about 2 - 3M new or updates rows per day. The master table has a materialized view log created using rowid. The full refresh of the view works and take...
Hi I'm using OracleCommand.ExecuteNonQuery() to insert into a table. Everything works fine but occasionally records are not inserted. So is it possible that ExecuteNonQuery() doesn't insert the record and also doesn't throw an exception? I'm not using stored procedures. I'm not using a transaction. I am logging any exception that is t...
I have a table with a Unique Index that I need to load 800,000 rows into. I altered the index and made it unuseable. I added 'options( rows=4000, bindsize=512000, skip_unusable_indexes=TRUE )' to my control file. I'm still getting errors of the form: ORA-01502: index 'x_Unique' or partition of such index is in unusable state Sugges...
I've discovered that the partitions used on a particular table are hurting query performance and would like to remove the partitions from the table. Is there an easy way to do this? The table in question has 64 partitions. Based on some initial investigation, I've come up with the following options. Is there a better way? Copy data int...
Hi all, For some reason i'm running a blank on how to go about doing something like this. I have a table that looks like this UserID | Name | DateAdded | LastUpated -------------------------------------------------- 1 | James Q | 1/1/2009 | If i insert or update record the lastupdated field should be updated the...
I have a table that contains a history of costs by location. These are updated on a monthly basis. For example Location1, $500, 01-JAN-2009 Location1, $650, 01-FEB-2009 Location1, $2000, 01-APR-2009 if I query for March 1, I want to return the value for Feb 1, since March 1 does not exist. I've written a query using an oracle analyti...
I am trying to put together an XML document from several pieces. To get the data, I had several queries whose results were XMLTypes. I found a function named getNodeFromFragment in the xmldom package that looked like it could take these XMLTypes and return a DOMNode that contained them, but it doesn't seem to work. Simple example here:...
Oracle'c COLLECT function triggers creation of a new collection type. Is there a way to disable this behavior ? here is what is happening ... check existing user types select object_name from user_objects where object_type = 'TYPE' no rows selected. create user data type with collection VARRAY wrapper type CREATE OR REPLACE TYP...
i have a table in a oracle database in which one of the field is a clob field. the clob field is having several xml file. now if i want to export that xml file into a text file on unix how do i do it? NOTE: i dont have any gui like toad installed for the server and i have to only use the unix environment for it. could you please tell m...
We have 200+ views in Oracle that should be transfomed to 200+ flat files with fixed length fields. Hoping to get ideas to do a better design of the following migration routine. The prototype of migration program looks like this for the view named VIEWNAME1 (and are the same for other views in the prototype): StronglyTypedDataSet view...
Hey all, I am learning to be a dba, and the one thing i am missing is good quantity of data to handle a database with. Someone on irc said if you cant handle few terabytes of data then you are still not good enough. My question is, is there a way i can have terabytes of data from somewhere that i can use it for my learning pu...