• Tablespace recovery

    Q1: How do i find out which datafile i need to recover when doing a tablespace recovery? Is it thru V$DATAFILE? Will oracle indicate this? Q2: Under which circumstances shld i consider recovering a datafile / a tablespace? It seems that i could recover a tablespace by just recovering a datafile (if...

    Mayleong0 pointsBadges:
  • SQL Server worst practices

    Hello, My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. Jeremy Kadlec, a performance and tuning expert at SearchSQLServer.com, recently wrote up what he considers some of the worst SQL Server practices and offered recommended fixes. You can see the list here:...

    Nbellistri0 pointsBadges:
  • Packages, Procedures & Functions

    What are the best practices for design with regards to packages, procs and funcs. More specifically, which schema to place these objects? The database contains a couple of schemas with tables that support the system. This is a DW system and one schema contains stage tables and the other holds the...

    DWdeveloper0 pointsBadges:
  • Upgrade to SQL Server 2005 sooner or later?

    Hello, I'm the editor of SearchSQLServer.com and I am hoping to get your opinons on a timely topic. Prior to Microsoft announcing its November 7 release date for SQL Server 2005, we had run a poll asking site members: How have the delays with SQL Server 2005 affected your organization's plans? 58%...

    RobynLorusso230 pointsBadges:
  • Email alerts and export report to Excel

    I'm running oracle9.2 on win2k. I need to do the following: 1) Run a script to monitor my storage percentage,number of extents of a tablespace, free space. After which i need to email this report to myself via MS outlook so that i have a record of this. The email shld be on a daily basis. This is...

    Mayleong0 pointsBadges:
  • Naming Constraints and Moving Tables

    Hi i hv started on Oracle9.2 running on win2k. A consultant we hired wrote all the shop floor programs and define all the tables, indexes, constraints. He also define for us the database config (init.ora). Because he is more into programming, i need to "clean-up" his act 1)Move all my uses even SYS...

    Mayleong0 pointsBadges:
  • Oracle applications Development

    I cant run net8 easy config after installing oracle6i on a machine currently running Developer 2000 forms 5. What do I do. Lekan

    Lekan10 pointsBadges:
  • Oracle Forms Developer/Builder for Oracle 9

    I have two questions. The first is, how would you go about changing the applet size when running a form? Or, is there a way? The other question is, how can you use Forms Builder to upload a file/document to the database? I need to load a filepath but I'm not quite sure how I need to get the file...

    WmFenn0 pointsBadges:
  • 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:

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