• What are the requirements for oracle10g Real Application clusters using ASM?

    Dear sir, what are the software reqiurements for configuring Oracle 10g real application clusters?

    Eamathew0 pointsBadges:
  • How to configure oracle 10g databses in two nodes and automatic storage management?

    I have a good knowledge about oracle 10g database configuration and oracle appln server configuration.We would like to configure that's as like a cluster.How to configure oracle 10g databses in two nodes and automatic storage management?

    Eamathew0 pointsBadges:
  • Number Crunching Machines

    I just started at a new workplace and have been presented with a group of servers running software called Calcserve. I'm not entirely sure what they actually do but it is some sort of number crunching for various trust funds etc. What concerns me though is that I have worked on AS400's now for...

    Neilm1m0 pointsBadges:
  • Sql ( I think i am almost there)

    after selecting all of my columns i joined the tables as follows FROM EMPL B, HB_EMPL_PKG_ELEC D, HB_EMPL_DEP_BNFIC A, HB_EMPL_MED_DEP C WHERE B.EMPL_ID = A.EMPL_ID(+) AND C.EMPL_ID = A.EMPL_ID AND C.BEN_PLAN_CD IN ('UHCALL','UHCBASIC') AND B.EMPL_ID = D.EMPL_ID(+) AND D.BEN_PLAN_CD...

    Alex88090 pointsBadges:
  • Calculation at database level

    Hi! Please take a look at few rows of one table . MBRNO Readmit READMIT DATE READMIT Readmit Seq. NO DISCHARGE date NO. of days 121 1 20030101 20030105 5 2 20030105 20030115 10 3 20030202 20030218 3 4 20030218 20020220 0 The measure is count of cases. I do not want to calculate the case with...

    Meenac0 pointsBadges:
  • City Based Website Portal

    I am working on project of starting a city based Portal. and was looking for ideas, which can make it success. the city is an industrial hub of Punjab (a state in india) Please suggest the contents.

    Andesh0 pointsBadges:
  • Please help

    Yet another question, and an example of my code. i have pulled some of the information that i need for the flat file by connecting to 3 tables, then sending the information i have chosen from the table into columns. i need to connect to another 2set of tables to add further information to my first...

    Alex88090 pointsBadges:
  • Oracle Partition

    Hi, I have a query that looks like select * from fact, dim_time where fact.my_dt = dim_time.clndr_dt and fact.my_dt between '1-jan-2005' and '10-mar-2005' this query eliminates partitions which are based on week. Now, if i replace the literal strings in the between clause with some kind of...

    Arunj740 pointsBadges:
  • Global SMS Web service API

    Are there any other Global SMS Web servics out there besides StrikeIron's offering? This service lets you build global text messaging functionality into your own applications without having to know the carrier of the provider. They are offering a trial with 5 free SMS messages:...

    NeilAbraham0 pointsBadges:
  • Direct insert into a remote Oracle RDBMS (not running SAP) from SAP. Can it be done from SAP?

    We need to insert SAP data directly into a staging table in a non-SAP app on a remote Oracle 9.2 DB. We've been given write access to only this one table in the remote Oracle DB. Currently, we create a flat file in SAP (on a DB400 DB), FTP the file to an intermediate Oracle DB owned by our group,...

    Hof11a0 pointsBadges:
  • Oracle query to count rows in tables

    Does anyone have a PL/SQL script to count the rows in all the tables in a given schema? No use reinventing the wheel... TIA, Mike

    Mikron20 pointsBadges:
  • DATABASE RECOVERY , WINDOWS 2000 , ORACLE 10G

    Hi Brian, I am a student at West Virgibia University, and manage a database with tables. My problem is that my system has crashed, I can get it up and running but on a different partition, so that my files are intact on the original partition, but my database wont run, because it was installed on...

    Deepakjha0 pointsBadges:
  • Conversion of de-duplicated Customer Numbers due to source system change

    We have a Data Warehouse which de-duplicates Customers from 3 operational systems to enable more accurate customer reporting, data mining & CRM activities. We have several month-end snapshots history. Our organisation is building a new Operation Data Store which will now take over the de-dupe & key...

    Szppt80 pointsBadges:
  • Connectin to a computer with oracle via internet, Error: ORA-12535: TNS:operation timed out

    I am trying to connect to another computer with Oracle 10G, via internet. I have defined a local service name, SRM, with the remote IP adress (which is a router/firewall), and port 1521. When i issue the commande TNSPING SRM I get a successfull reply: Ok, (100 msek), but when I test the service...

    Perherman0 pointsBadges:
  • ORA-00959 Error

    Hi, I am new to Oracle and I am trying to create a simple table as USER1. I connect as SYS and create USER1, USER2 as follow: CREATE USER "USER1" IDENTIFIED BY "user1pass" DEFAULT TABLESPACE "users" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK; GRANT "CONNECT" TO "USER1"; GRANT CREATE TABLE TO...

    JamesNguyen0 pointsBadges:
  • REFRESH SCHEMA WITH IMPORT

    To refresh a test schema using import from a production export, (rows=no, ignore=y -- or any combo), I wish to verify that for object code with the same name, (procedures, functions etc.) that the import will replace existing procedures, only replace procedures that are older than in the...

    Paralogist0 pointsBadges:
  • Oracle 9i Query Time

    What would be an expected time to run a query that will extract 1.4 million records? There are two tables involved. Customer and Address. And No Condition.

    Jummadaay0 pointsBadges:
  • Removing spaces between two words in SQL

    Hi, I have a table called employee and column called Name. The column Name contains (firstname lastname)i.e. firstname 'space' lastname. I want to retrieve just the firstname from the column Name for ALL the employees. I have tried using the function "substring" but since the firstname can be of...

    Kpatel0 pointsBadges:
  • Locate databases on an AS400

    Greetings. I recently "inherited" an AS400 model 720 after another staff member left. I'm a "newbie" with this system, but have been tasked to find the active DB2 databases still in use on the system. I can check my BRMS logs and see which libraries have changed from day to day, but I am unsure...

    Nadrel0 pointsBadges:
  • Database Admin.

    I'm currently in my 6th qutr. at ITT tech studying cns i'm interested in database admin. what skills or cert. will I need to get an entry level job? Where can I obtain such skills?

    Morpheus960 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following