User Profile

Collapse

Profile Sidebar

Collapse
gouthamirao
gouthamirao
Last Activity: Mar 14 '09, 06:09 AM
Joined: Feb 19 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • gouthamirao
    replied to Renaming user in oracle 9i
    in Oracle
    I have created a user with a password by logging in as sysdba. I dint specify the database name over there. Then I logged in by that username and password and created tables.
    See more | Go to post

      Leave a comment:

    • gouthamirao
      started a topic How to load CLOB using sqlloader
      in Oracle

      How to load CLOB using sqlloader

      I need to insert values into tables. I am doing it using sqlloader. Evrything is going fine, except the columns with CLOB datatype. I am unable to insert them, I am getting an error. This is the code I wrote:
      [code=oracle]

      load data
      infile *
      insert into table statusof_sites
      fields terminated by ',' optionally enclosed by '"'
      Trailing Nullcols
      (id,
      dc,
      df,
      cid,...
      See more | Go to post
      • gouthamirao
        replied to Renaming user in oracle 9i
        in Oracle
        I have created a user and inserted some tables with data using oracle9i. Can I know to which database these tables and user belong to? Do we have any command for knowing that?
        See more | Go to post

          Leave a comment:

        No activity results to display
        Show More
        Working...