• SQL Server equivalent of Oracle’s desc tablename command

    Thank you all for the response to my previous query. What is the T-SQL equivalent of Oracle's desc command? I mean, what is the command in T-SQL to see the structure of a particular table? And what do we do in T-SQL if we want to see list of all the tables in a particular database?

    Kpatel0 pointsBadges:
  • Oracle 9i Instance and database creation from the command line in WIN NT 2000

    Hi, Has anyone done this using Windows Authentication (the user is an admin and in the ORA_DBA group)? I used oradim to create an instance and did not specify any password. Instance was created but it gave me a TNS-12156 : TNS Protocol Error while connecting "connect /as sysdba". When I specify a...

    Sumeshs0 pointsBadges:
  • Versioning and merging products for oracle

    Has anyone been working with/implementing any versioning products with merging capabilities for oracle pl/sql? I'm hoping for some recomendations.

    Cleveland0 pointsBadges:
  • Linux based CRM systems

    I know several companies are working on Linux based CRM systems, but are there any commercial grade complete CRM products available on the market today (March 2005)? Thanks

    Japaninsider0 pointsBadges:
  • PMP transitioning from tech oriented projects to business oriented projects

    I am a PMP with 10+ years experience in implementation oriented projects (rollouts, user moves, infrastructure, NetOps, etc.) for internal clients. I want to transition to business oriented projects (SAP, PeopleSoft, SOX, SW development, etc.) for external clients. I am fully familiar with PMI...

    Johnnylac0 pointsBadges:
  • SQL Question

    I am migrating a query from MySQL to Oracle 9i. The query returns the error: ORA-00904: ?Y?.?CATEGORYID?: invalid identifier error message. Which means the column name entered is either missing or invalid. The SQL is below, if anyone can help me resolve this problem, your assistance would be...

    Tlroper0 pointsBadges:
  • SAPDBA not working in ORACLE database

    Dear BASIS Experts, SAPDBA is not working in one of my Server . When I run it gives the error The environment variable NLS_LANG =american_america.we8dec differs form DB value AMERICAN_AMERICA.WE8DEC. Adjust the environment according to DB value !. SAPDBA terminates because data corruption would be...

    PANTSK0 pointsBadges:
  • Problem Migrating from RBO to CBO.

    Hi everyone, I'm trying to migrate from RBO to CBO on an database. The problem I am running into is a little wierd. Some, not all, queries that have a distinct or a subquery in it doesn't return results. How do I get around this and what is happening? Example: SQL> select 2 b.po_id, 3...

    Dansken0 pointsBadges:
  • Database comparison

    I know this is 'cheating' but i was wondering if anybody had a quick way to compare two SQL2000 databases at an object level. I need to check the design of tables, code in Sp's etc. I think this can be done using systables, however i was wondering if anybody had done this and how easy it was. All...

    UselessOne0 pointsBadges:
  • Installation of Oracle9i client

    How to install Oracle9i client to c:program filesoracle and not to c:oracle on Windows Server 2003?

    Barusame0 pointsBadges:
  • SYS account problems with 9i

    Hi, When I try to login to the Oracle 9i database as sys, I am getting a TNS-12154 error. Surprisingly, I can log in as SYSTEM and another DBA account. The reason why I need to get in as SYS is to recompile the STANDARD package, as it has become invalid (?), ORA-6553 error and developers are not...

    Sumeshs0 pointsBadges:
  • Slow PL/SQL query

    I'm running the following query against two tables residing on an Oracle 8 database. The query takes too long (over an hour) to run. Both tables are indexed - however the main table SALES.SO is HUGE. Does anyone have any suggestions as to how I could improve this query so it can execute faster....

    Appioriley0 pointsBadges:
  • Domino Database Last Used

    Does anyone have any tools they developed to search all the databases on a server(s) and report on them based on the last modified or created date? Or even point me in the correct direction. I am a rookie. Thanks.

    Coachkaz0 pointsBadges:
  • Lost Passwords in Oracle

    I have joined a company very recently who deploy their product on both Oracle and SQL Server platforms. Theyt seem to have no clue about their dba access passwords for Oracle. How do I get to these passwords? Is there a backdoor or utility which can help me get the passwords on these databases?...

    Sumeshs0 pointsBadges:
  • oracle performance tunning

    Anyone who can share an experince with session_cached_cursosrs: conditions to use, value & desired results - will get a virtual drink. TIA!

    Xlander50 pointsBadges:
  • CLOB – Fetch out of sequence

    I am inserting into a table which has a CLOB field. I insert a blank_clob and then try and retrieve the clob field again directly after insert. When I execute the select to retrieve the CLOB field I am getting ORA-01002: fetch out of sequence. The query looks like: select XML_DATA from XML_TABLE...

    GinaOL0 pointsBadges:
  • Data Architect career path

    I currently work as a data analyst creating reports within an access environment, and in addition have Oracle SQL and Business objects reporting skills. However I am keen to change my career path towards becoming a data architect, and would like to know what training courses to take in order to...

    Guguru0 pointsBadges:
  • Unix ODBC Drivers

    I am looking for an inexpensive way to do a pull of Sqlserver data into Oracle using Native Oracle Sql Statements to select the data from Sqlserver. This request would be easy to fulfill if there were an ODBC driver for Unix. I have found such drivers but they are expensive ($4000 per CPU on Unix...

    Jk666380 pointsBadges:
  • Database and Web Server Technology Choices for Small Database Application

    Hello, We are developing a small web-based database application that will need to be accessed by all department staff and managers (maximum 100 clients). Internet access to the database from outside the Agency is not required. It is not desirable to install any client software other than MS-Windows...

    Mmosystem0 pointsBadges:
  • Oracle Application Remote Administration

    Hello Sir/Madam/Mrs/Ms, i'm not sure whether is this the right platform asking my type of questions, but just go ahead. I have an Oracle database server and application server at Premise A. Right now i'm in Premise B which is geographically apart from Premise A about 365km. I want to access Oracle...

    Mofazha0 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.

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