Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gmennessier

    function MONTH

    A little harder now. I have a request which ran under SQL server, but when I try with Oracle, it bugs: SELECT Sum(RAPPORT_MAINOEUVRE.DureeIntervention) AS SumDuree, Count(RAPPORT_MAINOEUVRE.refRapport) AS Actions, TO_CHAR(DateCreation,'MM') AS Mois, TO_CHAR(DateCreation,'yyyy') AS Annee FROM...
  2. gmennessier

    function MONTH

    Hi everybody! I've got a problem, I'm programing in ASP and I want to do: SELECT MONTH(date)as mois,year(date) as année FROM LOGON But it returns the error: Microsoft OLE DB Provider for Oracle error '80040e14' ORA-00904: "MONTH" : identificateur non valide What does it...
  3. gmennessier

    importation problem

    Context : Importation of data from SQLserver 2000 to Oracle 9i I manage to import data from a SQLserver database with the "migration workbench" in oracle 9i. This process returned a success mesage but I am unable to find my tables in the target database. The process created a file...
  4. gmennessier

    Migration Workbench doesn't walk!!!

    I want to import a sql server database. But when I run the migration workbench, it returns an error message. Please, tell me what to do? Thanks :-)
  5. gmennessier

    I want to create a new database with Console Oracle Entreprise Manager

    I've just installed oracle 9i. I cannot connect to sql+. So I want to create a new database in which Iwill import a sql Server database. But when I click on create... database, It is wrote: "No session is selected" (I 've got a french version and I translate approximatively the...
  6. gmennessier

    migrate database from SQL Server to Oracle 9i

    Could anyone tell me how I must do, step by step, to migrate a database from SQL Server to Oracle 9i ? Thank you
  7. gmennessier

    How can I run catalog.sql?

    In the oracle doc, it is said that I must run catalog.sql. But I wonder how. And when I click on Oracle migration assistant, nothing appears. So where can I execute my migration instructions (SQL Plus? ...oracle explorer?...) Could you help me please?
  8. gmennessier

    migrate database from SQL Server to Oracle 8i

    Hello, I want to import database from Oracle 8i. It is actually a SQL Server database. What must I do ?

Part and Inventory Search

Back
Top