DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: partition table & indexes

Threaded View

  1. 05-21-2003, 12:51 AM #1
    PSoni
    PSoni is offline Member
    Join Date
    Feb 2001
    Posts
    125

    partition table & indexes

    hi all,


    We have created a user specifying default tablespace.
    when we are importing data from dmp, we noticed that
    some of the indexes and partition tables are inserted
    in the SYSTEM tablespace instead of default tablespace.

    For our original data, from which we had taken dmp.
    We had created user and specified default tablespace.
    but during table creation (we are using partition table)
    we didn't specify tablespace. where is the problem?? and what is solution to get back indexes and tablespace into default tablespace without recreating table.


    awaiting ur replies
    thanks
    Last edited by PSoni; 05-21-2003 at 12:54 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width