Search results for query: *

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...

My developer runs a query that inserts records into a table that has one column with LONG data type. He also enters records into two other tables that dont have a long column. He is persistenlty getting ora 1013 on the one with LONG data type but never on the other tables. Any one has...

With 8i gone - we lost DBA Studio. I guess we have to use the manager consloe to go to enterprise manager. How do you now add a database to the tree. I believe you need to discover the node and it will add the instance to the database list. For that you need to run the agent on the server. Am...

One of my users is trying to link an Oracle 8i table from Access 97 and cant do it. Another user using Access 2000 can do it. The one with Access 2000 says that the table has function based indexes and thats why he is having problems. Does any one knows about the issue here. Thanks in...

1) Is it true that using an INTEGER datatype (for data that will not have any decimals) is better from performance standpoint than using a NUMBER datatype. 2) How do you tell who created a user role. There is no coulmn such as role owner in any dictionary table. Regards, Naushi Hussain...

The how do you start and stop an instance for windows Regards, Naushi Hussain Naushi.hussain@honeywell.com