• Fields indexing

    Topic: SQL Question: My question is regarding fields indexing. My table named' K5Details' contains about 200,000 records and the response time to access this table is quite slow. What is the best way to index this table in order to get better response time To this table, I've created few indexes....

    Azizah0 pointsBadges:
  • Extracting SAP R3 data in custom DW

    We are in the process of building a custom data warehouse (SQL with Business Objects Universe for reporting) - this is continuing the existing company strategy. The difference this time is that we need to extract data from SAP R3 to feed into the warehouse. What I'm not sure about is the best...

    Jroth730 pointsBadges:
  • ASE Trigger

    select @command = 'INSERT INTO tablename SELECT * FROM inserted' execute(@command) Hi all, i am building a dynamic SQL Command inside a trigger, i received an error message that table inserted is not found. (i am using ASE 12.5.1) thanks,

    Ghassanhaith0 pointsBadges:
  • Data transfer Job

    I want to Import Data from SQLSERVER 2k into Oracle. Tell me the way to do it quickly.

    Sabyad0 pointsBadges:
  • Import utility in Oracle

    When importing a table (as a means of restoring), and specify ROWS = Y, does the data in the table get overridden?

    Mayleong0 pointsBadges:
  • Unable to create new records in other database using local form (writing background agent)

    Hi, I am trying to create an agent in a database that creates a new document in the local address book using its local form (Person). Debug shows that all is fine except that it does not save (the flag value is -1). What am I missing? Here is my code: Sub Initialize Dim s As NotesSession Dim...

    Arnaud660 pointsBadges:
  • Should you ever consider creating a fresh database for a user’s e-mail?

    On our Domino server, there is one mailbox that keeps generating errors. It is flagged in STATREP.nsf daily because documents can't be created or mail rules are problematic. I am unable to view the Rules in the database, and in Domino Administrator, it's the only mail file that doesn't show a...

    DKoch675 pointsBadges:
  • Configuring OEM to access Oracle on 2 systems

    Background: oracle_sid=opteldb runs on win2k v9.2.0 (IP=10.201.132.40) oracle_sid = GLDBWH runs on solaris 2.6 v8.1.7(IP:10.201.135.101) OEM is configured on win2k (client platform--not the oracle win2k server). I now can access opteldb and tnsnames.ora is configured with opteldb (stored in...

    Mayleong0 pointsBadges:
  • Trying to solve ORA-00980: synonym translation is no longer valid

    I ran the catalog.sql script on my Enterprise DB in preparation for exporting a schema from my Oracle 9i version 9.2.0.1.0 Enterprise DB with an Enterprise Manager Server and Intelligent Agent to an Oracle 9i version 9.0.1.1.0 Personal Edition DB(Each DB running on separate PCs in my LAN). I ran...

    Aascotty0 pointsBadges:
  • time-based & change-based recovery

    i was reading abt these methods of recovery. In classrooms, the lecturer always simulate this sort of recovery by noticing the time (for time-based recovery), or the log seq# (for changed-based recovery). In reality, there will always be careless users who deleted a record they shldnt and now...

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

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