User Profile

Collapse

Profile Sidebar

Collapse
raviva
raviva
Last Activity: Aug 25 '08, 02:33 PM
Joined: Jan 22 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • raviva
    replied to Loading Excel File into Oracle Table
    in Oracle
    All I am doing is downloading the excel file and converting the excel file into CSV(manually). I wanted to know is there a automated process which converts the excel file into csv?...
    See more | Go to post

      Leave a comment:

    • raviva
      replied to Loading Excel File into Oracle Table
      in Oracle
      Any idea on this??

      Ravi...
      See more | Go to post

        Leave a comment:

      • raviva
        replied to Loading Excel File into Oracle Table
        in Oracle
        I download the file from a website, it will be in excel format. then i save it as csv and then ftp it to unix box and run the sqlloader......
        See more | Go to post

          Leave a comment:

        • raviva
          started a topic Loading Excel File into Oracle Table
          in Oracle

          Loading Excel File into Oracle Table

          Hi,

          I need to create a script [preferably Unix+sqlldr] to load Excel file into oracle tables. Please help if you have worked on anything like this. I have been doing this converting Excel to CSV manually and then running the script(sqlloade r). Is there a script which can automate this process.

          Thanks
          Ravi
          See more | Go to post
          • raviva
            started a topic File too large..
            in Oracle

            File too large..

            Hi,

            When I am trying to uncompress a export dump file. We have HP-Unix OS and the application is Oracle 9i. It says that the File too large. I have checked the space in the file system and it has enough space. Please help me. I am getting nervous.

            Thanks,
            Ravi.
            See more | Go to post
            • raviva
              started a topic File too large..
              in Linux

              File too large..

              Hi,

              When I am trying to uncompress a export dump file. We have HP-Unix OS and the application is Oracle 9i. It says that the File too large. I have checked the space in the file system and it has enough space. Please help me. I am getting nervous.

              Thanks,
              Ravi.
              See more | Go to post
              • raviva
                replied to TOADS Explain plan
                in Oracle
                Thank you very much Veena it worked!!

                regards,
                Ravi...
                See more | Go to post

                  Leave a comment:

                • raviva
                  started a topic TOADS Explain plan
                  in Oracle

                  TOADS Explain plan

                  Hi,

                  I want the explain plan. But when I clicked on the explain plan it says ORA-02404: specified plan table not found. I investigated on net and some books. I was asked to load the utlxplan.sql. I did that but of no use. I also changed the name of the plan table in TOAD, still no use. New thing I heard recently is to run TOADPREP.SQL. But this script is not available on our server($ORACLE_ HOME/rdbms/admin). Can someone please suggest...
                  See more | Go to post
                  • raviva
                    started a topic FTP Batch file
                    in Oracle

                    FTP Batch file

                    Hi,

                    I have a question regarding the batch file. When that batch file is run, its ftps a csv file from windows to oracle end(ours is on unix platform). This is quite simple right?? But there are somethings I am unable understand in that file: Please have a look at the batch file below:

                    @echo off
                    ftp -n -s:.\FTP_CMDS\CT DI.FTP 135.65.246.214 > logs\CTDI_FTP.l og

                    In the above batch file, I am confused...
                    See more | Go to post
                    • raviva
                      started a topic Tuning a stored procedure
                      in Oracle

                      Tuning a stored procedure

                      Hi,

                      This is Ravi again. We have some jobs running in Oracle 9i. We have that stored procedures in TOAD. Right now we are expreriencing a degration in the performance of the procedure. It is taking unusually long time to run. Can you please direct me in this issue on how to improve the performance level.

                      Thanks,
                      Ravi
                      See more | Go to post
                      • raviva
                        replied to Access violation at address 00000364. Read of address 00000364
                        in Oracle
                        Thank you very much for the valuable information.

                        Ravi....
                        See more | Go to post

                          Leave a comment:

                        • raviva
                          started a topic Access violation at address 00000364. Read of address 00000364
                          in Oracle

                          Access violation at address 00000364. Read of address 00000364

                          Hi there,

                          Can someone please explain me about the follwoing error. When I click a table name in schema browser in TOAD. I got this message.

                          "Access violation at address 00000364. Read of address 00000364"

                          Thanks,
                          Ravi
                          See more | Go to post
                          • raviva
                            replied to Connecting to an SQLServer
                            in SQL Server
                            Thank you very much. It worked....
                            See more | Go to post

                              Leave a comment:

                            • raviva
                              replied to Connecting to an SQLServer
                              in SQL Server
                              Thanks, but the server which I want to connect doesnt appear in the available servers list. I wonder, if I have enough data regarding that server. I know the server name, IP address. Are these parameters enough, or additional what information I need. Further, what needs to be done to appear our target server name in the available servers list. Sorry, but I am very much confused.

                              Thanks....
                              See more | Go to post

                                Leave a comment:

                              • raviva
                                replied to Connecting to an SQLServer
                                in SQL Server
                                Thanks. However, can you a bit more specific. I have added a new datasource, but of no use. I have the IP address of the other server.

                                Thanks...
                                See more | Go to post

                                  Leave a comment:

                                • raviva
                                  replied to Connecting to an SQLServer
                                  in SQL Server
                                  I am trying to connect from enterprize manager......
                                  See more | Go to post

                                    Leave a comment:

                                  • raviva
                                    started a topic Connecting to an SQLServer
                                    in SQL Server

                                    Connecting to an SQLServer

                                    Can someone please explain me how to connect from my SQLServer to a remote SQLServer. Both the servers are 2000. I have tried linked servers but it is quite confusing.

                                    Thanks,
                                    See more | Go to post
                                    • raviva
                                      started a topic Hardware upgrade
                                      in General

                                      Hardware upgrade

                                      Hi there,

                                      I am Ravi. I work for a big company. I task I have is to get a quote from the HP guys for the new hardware. We have two servers, P1 is the production server and P2 is the back up and test server. The specifications for the servers are as follows:

                                      System Name p1 p2

                                      Vendor HP HP
                                      Model rp5470 ...
                                      See more | Go to post
                                      • raviva
                                        started a topic Heterogeneous Database connections - Oracle to SQL Server
                                        in Oracle

                                        Heterogeneous Database connections - Oracle to SQL Server

                                        Hi, my name is Ravi. I got a new task of connecting to an SQLServer remotely from our Oracle Server. We have our database on Unix server. Please assist me regarding this connection.

                                        Thanks,
                                        Ravi.
                                        See more | Go to post
                                        No activity results to display
                                        Show More
                                        Working...