Member Avatar for shapam

i have a doubt.. once i created new user called user1 in oracle database with default tablespace say user1, if i import data from user tablespace, after that the data will occupy space user tablespace only. i want to know how to move data from user tablespace to user1 tablespace. i checked this issue using the below query. sql>select segment_name,tablespace_name from dba_segments where owner='USER1'; the result showing user1 segments are there is user tablespace not in user1 tablespace. please give me idea to fix this issue..

Edited by shapam
  • 2 Contributors
  • 1 Reply
  • 138 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by HTMLperson5
Member Avatar for HTMLperson5

why not use the "move table" command to move tables. Then recreate your indexes.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.