Search results for query: *

Hi I have create a new table without primary key. I insert a row with column A of value 3345.Then I insert another row with column A of the same value 3345. The rest of the colume(column B ...Column z) also become duplicate of each other.Why is this so? I need the rest of the column to remain...

Hi I need to load data from excel spreadsheet into oracle8.05 database daily. I need a method to run this loading automatically .Have anyone come across a tool/method ,pls advise. Thank in advance

Hi I'm evaluating ms access software for my company .Would like to know is there any ms access enterprise server available in the market and any sites to refer to. Thanks in advance

Hi, Currently I am using Oracle 9i release 2. I have a requirement for it to work through a cisco firewall. My TNS listener is at TCP port 1521. I understand that USE_SHARED_SOCKET = TRUE in registry should be able to allow clients and server to communicate using only TCP port 1521. However...

Hi I trying to use oracle 9i management server to discover a node(running oracle 8.0.5 oracle intelligent agent) but it fail. I have ensure the oracle 8.0.5 intelligent agent is up and running. Why isn't the oracle management server of oracle 9i still unable to find it. Is it because of oracle...

Hi I now in the middle to purchase standard 2003 server or advanced 2003 server. Can anyone advise me the requirement to consider when deciding which is suitable for me. I am using a HP server running 4GB memory and 4x Xeon 2.0GHz processor with 105GB diskspace(Raid 5) Thanks in advance

Hi Hi We're running oracle 8.0.5 on window NT 4 currently. We are purchasing a new server which will install Windows Svr Ent 2003 with oracle 9i. My Question is where this O/S will face any technical problem or conflict with oracle 9i. Is there any thing to note or problems when migrate...

Hi Have a simple question ,I can't remember the command to check the disk space used by a directory that contain some files. It is not ls -l cause it wont show the total diskspace used by all the files .I also do not wan wish to use du command cause manually still need some caculation...

Hi I need to know the network traffic cause by my database . Anyone can advise on any sql command or method which I could view total number of transaction generated by my database. Any Help is appreciated. Thanks in advance.

Hi I experience something weird here. I try to access an Oracle table through Ms-Query. Though I can read it through Ms-Access and ODBC test, with both Oracle and Microsoft for Oracle drivers, when I try with Ms-Query, I get an "ORA-00903 Invalid table name" I also discovered that...

Hi Anyone can update me whether currently do we need to renew oracle license annually? Another question : if i stop renewing my oracle support license ,am i still able to continue to use my oracle product? thank in advance

Hi I running oracle 7.3.4 on winnt 4.I need to find out which type of port I using. Any can advise thks

Hi How can I view all the built in package of oracle database. (by SQLPlus command or any oracle tool) Pls advise

Hi I trying to setup replication manager for two oracle database version 8.05 running on window nt4. The purpose is to replicate tables from one database to another. During the setup there is a error msg appear : Error while creating link from Atlas_Dev to Atlas_Dev2 SQL TEXT ...

Hi I running oracle 7.3.4 on hp9000 series machine.I intended to get a new hp machine running oracle9i. I came across term like 32 bit or 64 bit oracle during my research for installation/migration. Can anyone pls advise the difference between these two term. How can I know whether my existing...

Hi all I'm running two database : 1)oracle 7.3.4 on hp ux 10.2(128mb , p166 processor) 2)oracle 8.0.5 on win nt4 (4GB ram ,4x400MZ processor) We are purchasing a new oracle 9i on hp ux11i(2GB, 2x700 risc processor) and would like to migrated both existing database to the new oracle9i...

Hi Can anyone advice which file in my c drive is holding all my existing mail. I would like to copy back after i reinstall my new outlook express thank in advance

Hi Anyone able to recommend free and user friendly tools that can used use to monitor oracle8i database on HP UX (Table ,tablespace SGA ,instance,etc). Thanks in advance.

Hi I am trying to install a new oracle 8i on HpUx 11i. I have not decide my final parameter yet like size of Shared Pool, DB buffer cache,Log buffer cache,datafile redo file etc.I may need to change after installation. Can I re-adjust all these parameter later after i had install oracle8i...

Hi I face some difficulty when modify my existing cronfile and schedule a new job eg.(10 12 * * * cd /data/schedule; ./elpida_link > /data/schedule/elpida.log) After modify and saved the cronfile (vi cronfile) ,i issued a command "crontab cronfile" to submit the new cronfile to...