partition table & indexes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: partition table & indexes

  1. #1
    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 01:54 AM.

  2. #2
    Join Date
    May 2001
    Posts
    736
    This has been discussed lot of times.

    Check this post

    http://www.dbasupport.com/forums/sho...ghlight=export

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758

    Re: partition table & indexes

    Originally posted by PSoni
    and what is solution to get back indexes and tablespace into default tablespace without recreating table.


    awaiting ur replies
    thanks
    ALTER TABLE MOVE...
    ALTER INDEX REBUID ONLINE....
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

Posting Permissions

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


Click Here to Expand Forum to Full Width