Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    9

    Question Unanswered: Move Table from DMT to LMT

    I have a table (cgo_port_revenue) in a DMT and would like to move this table to another tablespace (ts_dmpdss_dta08) which is a LMT one. Yet the following error occur when I did the move:

    >alter table cgo_port_revenue move tablespace ts_dmpdss_dta08
    pctfree 5 pctused 40;

    alter table cgo_port_revenue move tablespace ts_dmpdss_dta08
    *
    ERROR at line 1:
    ORA-01659: unable to allocate MINEXTENTS beyond 9 in tablespace TS_DMPDSS_DTA08

    Can any expert give me a hand?

    Thanks/KS.

  2. #2
    Join Date
    Jul 2003
    Location
    Near Paris France
    Posts
    60
    Your target tablespace is too small. Add a new file to your tablespace or use an other tablepsace

Posting Permissions

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