Search results for query: *

Hi there, Can someone please tell me how do you identify all the virtual IP's defined on a 3 node Sun cluster? Is it as easy as doing a "ifconfig -a" and looking for something specific, or is there a more scientific way? As you can probably tell networking is not my strong point! For what it's...

Hi there, I have a strange problem with my scheduled SSIS package. When I remote desktop into the server using my local windows account user "HOMER\dba", I see my job succeeds (while I am logged in). I can also right click on the job and start it, the job will then run successfully. BUT, when...

Hi there, I am VERY new to reporting services, and started playing with it recently. I am also using the lessons on www.databasejournal.com to learn about this product. I have a few questions on reporting server functionality that I hope someone will be able to answer.. Is it possible to...

Hi there, I have a table in SQL Server with a datetime field. I got the data from Oracle using the import wizard. The data looks as follows in SQL Server: 2006-08-07 10:40:00.000 2006-08-07 10:45:01.000 How can I change this to display as: 10:40:00.000 2006-08-07 10:45:01.000 2006-08-07 In...

Hi there, I have 2 pieces of SQL that I run in Query Analyzer (SQL Server 2005). The first one gives me the correct result - 1.5, the second one not - 1.0. 1: declare @tmp decimal(10,2) set @tmp=3 set @tmp=@tmp/2 select @tmp ===> 1.5 2: select 3/2 ===> 1.0 I stumbled upon this when I was...

Hi there, I need to write a script that has to ftp certain files from 1 server to another. I will hard code the directories, files and the username that will be used in this ftp file (lots of users will be using the same file). The script must only prompt the user for the password. The plan is...

Hi there, I hope someone can shed some light on this... We have a partitioned table in Oracle, partitioned by month (+- 1 500 000 records per day, +- 35 000 000 records per month) ie. test_tbl: partitionkey number; my_otherkey number somedatefield date; select...

Hi there, I am having problems logging in to my 10G DBconsole. I have installed Oracle 10G on Windows XP. I can successfully open the DBConsole loging screen, but when I type in valid login credentials the login screen just reappears after loading a while. When supplying the incorrect login...

Hi there, Apologies if this looks a bit long-winded, but I believe it is an interesting issue if someone can help! :) I was wondering if someone can please explain to me how SQL Server works out the following execution plan. The query does not execute slow, as a matter of fact it is very...

Hi there, I want to do a complete refresh of a MV in another user's schema. I have the following privileges granted to me: DBA CONNECT DW_USER DEV_USER RESOURCE ANALYZE ANY CREATE TABLE DROP ANY VIEW CREATE SESSION ALTER ANY INDEX ALTER ANY TABLE CREATE ANY VIEW CREATE SNAPSHOT CREATE ANY...

Hi there, Is there an easy way to find the problem column/error record of the above mentioned error? I just do not want to go through all 30 columns and it is especially a problem if you need to insert millions of records. Thanks, J.

Hi there, I created a compressed tablespace with an empty compressed partitioned table in database B. I exported the data from database A (uncompressed) and imported it into database B, but when I looked the data in database B was not compressed ? Any ideas on why oracle would not compress the...

Hi there, I successfully set up a connection to a SQL Server database from Oracle using Oracle's transparent gateway. I can query tables, but I want to know if I can execute a procedure on SQL Server FROM sqlplus via the transparent gateway. Any ideas? Thanks, J.

Hi there, I successfully set up a connection from Oracle 10G running on Windows to a SQL Server database (after some struggling 'cause Oracle's documentation is absolutely shocking regarding this). Anyway, I want to know if anyone has set up a connection to a SQL Server database using Oracle's...

Hi there, I want to start to learn how to do web development. I do have some background using Macromedia's Coldfusion, but want some feedback from some more experienced users. - What is the best tool to use? I read alot about Dreamweaver, can someone give me some advice whether to make...

Hi there, Does anyone have an example of how to insert data into a table from a given text file? I think I need to use the "utl" utility, but have never used it before. Thanks, J.

Hi there, Is it possible to create a foreign key relationship to be able to insert a record with null values (on the FK colum) on the child table? The reason is that the process that loads the data in the database loads some records in the child table before the parent table. I know it is...

Hi there, I am receiving the dreaded ORA-03113 error when I try to connect to my database as user A as follows: . oraenv MYDB sqlplus "usr/pwd" but when I connect as follows: sqlplus "usr/pwd@MYDB" I can connect to the database. As the ORACLE user I can connect to the database using both...

Hi there, I have just recently started using RMAN and have a few questions I hope someone will be able to assist me with. Some background info first: Oracle 9i Release 2 I have created a catalog database We perform online backups every day including the controlfile, arcive logs...

Hi there, I recently started using Veritas Netbackup to backup our database online using the build-in RMAN scripts. The backup works fine, and I can restore the database BUT only if the database is in a mounted state, i.e. so I can only perform a restore if I lost a data file or something, but...