Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004

    Unanswered: script to add/insert data into tablespace

    Hi All:

    Newbie here.
    I am testing backup; in addition to default system, users, temporary tablespaces, I have created "test1" tablespace.
    I am trying to add more data into that test1 table space, so that I can run some backup & restore plus restore to point in time.

    Load, insert, and other command require data with index, which I don't have to begin.

    Can anyone provide a script to add more data into a tablespace?

    Thanks in advance

  2. #2
    Join Date
    Nov 2004

    insert data

    you never insert data into a tablespace but into a table
    insert - import - load does not require an index
    insert into xxx(col1,col2..) values('bb',11,....)
    import from xxx of yy insert into
    load from....
    Best Regards, Guy Przytula
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts