Recent content by naushi

There are two dates date1 and date2 that need to be compared in a SQL. If date1 is greater than date2 I would select date1 and compare it in my where clause to be between start-dt and end-dt. If date2 is > than date1 then I would select date2 and compare it to be between start-dt and end-dt in a...

I am trying to compare packages on two databases on different servers. I just want to compare the names. What is the best way to compare the names of local packages. I cant find them in any sys table so I could do a query to compare. Any help will be appreicated. Regards, Naushi Hussain...

Is there a way to auto truncate or drop the table when you refresh data in a table from an outside table. Right now it is appending to the existing table. I couldn't see any option for truncate. Regards, Naushi Hussain Naushi.hussain@honeywell.com

I need to transfer tons of data from server A to server B. I am choosing bcp since DTS could be slow. In the bcp out command in server A, can I use the directory of the server B so the file will be directly created in server B and then i can bcp in it. Second choice is (if the first one is not...

Does any one work with GIS database. We are trying to get training here and need to justify it. I like to know what type of applications is it used for. Any help will eb appreciated. Regards, Naushi Hussain Naushi.hussain@honeywell.com

I have a table where I want the user to be able to select only coulmn 1,2 and 3 and be able to update only column 4. Any idea how can I arrange permisisons. For the first one I have no problem since I can create a view for col 1,2 and 3. and give select permission on the view. What will I do...

When you define a column with data type integer it converts it to Number(38). does any one know how much space in numbe r of bytes does it allocate. If we insert a small value like 2 or 3. will it still occupy the entire allocated space or it works like varchar2. will appreciate some help...

I am trying to load data into a table using sqlldr. everything works fine but the records with NULL date do not get loaded and they appear in the bad file. I am using 'trailing nullcols' in my load statement. I am also using NULL if ... = blanks. default if ...= blanks The column in the table...

Is there any place I can get Oracle 9i performance benchmarks against Oracle 8i. Just need to justify that 9i is faster than 8i. Regards, Naushi Hussain Naushi.hussain@honeywell.com

I am going to be creating an OEM repository and monitoring some servers. My task is to report some servers for UP and DOWN status, number of users threshold reached etc. I though have no problem building all this but dont know how to accumulate the status or the results and build some kind of...

I am trying to query CLOB and BLOB columns from a linked database (select....from table@linkname). I get the error 'remove the LOB objects from your query. Any one has any idea if this is possible or there is a work around it. Thanks. Regards, Naushi Hussain Naushi.hussain@honeywell.com

I have to select all the columns from a table but I want to display one column with supressed leading zeroes. I can use ltrim(col,'0') for the specified column and it does supress the xeroes. How can I use select * from.....without having to type the rest of the column names. Is ther ea way to...

I need to run a full export using gzip, which I already have set up and run. Total size is 930MB which is too big to burn on a single cd. Does anyone have an example of an export that not only uses gzip but also uses the FILE and FILESIZE parameters to split the dmp file into smaller files ...

Robbie, Thanks so much for the help. It worked. Now I am getting the following error on each record. finds_repair_order is the table name - any clue? Record 1: Rejected - Error on table ECLIPSE.FINDS_REPAIR_ORDER. ORA-01008: not all variables bound This Error has no action suggested in the...

I have a file that was bcp'd out of SQL Server. I am trying to load it into an Oracle table and getting an error on date format. The date column is coming in as follows from SQL Server which I have no control over. 1994-03-28 10:57:27.000 I have used the following formats in my control file...