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

Answer Question   |  July 8, 2005  6:08 AM
Development, Oracle

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 [...]

Answer Question   |  June 7, 2005  10:08 AM
Oracle, SQL, Visual Basic

Stop Error (C000021a)
I am receiving this stop error(C000021a) “windows logon process system process terminated unexpectedly” with win 2000 server. Safe mode and Last Known Good Conf. works fine. Is there any solution without reformating the HDD? I have ERD with me. Will that help me? Any advise on this would be highly appreciated. Thanks

Answer Question   |  June 23, 2008  3:29 AM
Biometrics, Call Centers, CIO, Compliance, CRM, Customer relationship management applications, Data analysis, Data center operations, Data mining/analysis, Data warehousing applications, DataCenter, Desktop management applications, Desktop security, Desktops, DHCP, Digital certificates, Disaster Recovery, DNS, E-mail applications, ERP, Exchange, Graphical User Interfaces, Hardware, Help Desk, IBM, Identity & Access Management, Implementation, Information risk management, Installation, Intel, Intel PC hardware, IT architecture, LANDesk, Microsoft Systems Management Server, Microsoft Windows, Networking, Networking Products, Networking services, Operating system platforms, PeopleSoft, Performance/Tuning, Physical security, Policies, Power management, provisioning, Registry, Risk management, Security, Security management, Security products, Security Program Management, Security tokens, Servers, Single sign-on, System utilities, Systems management software, Tech support, Third-party services, Vendor support, Vendors, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance

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 sub-queries that provide the values at run time, [...]

Answer Question   |  June 6, 2005  8:09 PM
Application software, Development, Oracle, Tech support

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

Answer Question   |  May 27, 2005  12:22 PM
Oracle, SQL, T-SQL

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: http://www.strikeiron.com/htmls/pws_global_sms_pro.aspx What do you think?

Answer Question   |  June 2, 2005  10:36 PM
BEA, BEA WebLogic, Cape Clear Cape Connect, Hardware, IBM, Microsoft .NET, Microsoft Windows, Oracle, PeopleSoft, Plumtree, SAP, Sybase, Systinet WASP, TIBCO

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.

Answer Question   |  June 8, 2005  1:46 AM
Application software, BEA, BroadVision, Business/IT alignment, Career development, CIO, Citrix Systems, Computer Associates, Corporate portal applications, Desktops, Development, Distribution/logistics applications, E-mail applications, Epicentric, ERP, Exchange, Handhelds/Phones, Help Desk, Implementation, Information risk management, IT architecture, Knowledge management applications, Networking Products, Operating system platforms, Oracle, Peripherals, Planning, ROI & cost justification, Security, Security management, Servers, Services, Storage, Supply chain management applications, System utilities, Tech support, Third-party services, Vendors

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 using [...]

Answer Question   |  May 17, 2005  6:51 AM
Networking, Oracle

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 export.dmp, or not replace them?

Answer Question   |  May 13, 2005  3:26 PM
Oracle

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 persistency functions. The ODS uses more up to [...]

Answer Question   |  May 18, 2005  2:03 AM
CRM, Customer relationship management applications, Data warehousing applications, IBM, Oracle

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 “USER1″; When I connect as USER1 [...]

Answer Question   |  May 16, 2005  7:57 PM
Oracle

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.

Answer Question   |  May 6, 2005  11:45 AM
Database issues, Database Management Systems, in use in organization, Oracle, s, Total size of the database, Very Large Databases

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 [...]

Answer Question   |  June 1, 2005  2:55 PM
Basis, Interaction Center Technology, MySAP, mySAP Enterprise, Oracle, R/3, SAP, SAP development, Workflow

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 [...]

Answer Question   |  May 24, 2005  4:25 PM
Database Management Systems, Microsoft Windows, Oracle, Oracle 10g

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 [...]

Answer Question   |  April 25, 2005  3:45 PM
Database, DB2, Oracle, Tech support

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 VARIABLE length, I do not know [...]

Answer Question   |  April 26, 2005  4:40 PM
DataCenter, MySQL, Oracle, SQL Server

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?

Answer Question   |  April 13, 2005  9:08 PM
Database, DataCenter, DB2, Oracle

Importing Data in SQL Server 2000. “Integrity violation error” in RowID column
Hi All, I have a table called Employees(RowID,EmpNo, Lastname, Firstname). Here RowID is autogenerated by the system. It is the primary key and DOES NOT allow NULL values. I CANNOT change the table structure. I am trying to import data from a text file through the Import Data Wizard in the Enterprise Manager. The textfile [...]

Answer Question   |  April 8, 2005  7:18 PM
Database Management Systems, MySQL, Oracle

Loading CSV files into Oracle tables
I want to load data from the Microsoft Excel sheet to my Oracle 8i database. Can I achieve this using TOAD? This question posed on 10 March 2005 You cannot use TOAD to move your data from MS Excel to Oracle. You can save the Excel spreadsheet as a comma-separated-values (CSV) or text file. Then [...]

Answer Question   |  April 19, 2013  11:46 AM
Corporate Financial Applications, Database Management Systems, ERP, Financials, Human resource applications, Informix, iReceivables, Microsoft Access, Oracle, Payables, Procurement, Projects

Help with VBA Code for retrieving data from a table in an MS Access Database
Hi, I’m new around here. I’m a student in the programming field. I have a question for those of you with experience with VBA, VB, or SQL coding languages. Basicly what I’m looking to do with my database is have it fill in the remaining related fields in a form when the Primary key field [...]

Answer Question   |  March 30, 2005  12:59 AM
Database, DB2, Oracle, SQL, VBA, Visual Basic