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..
shapam 0 Newbie Poster

HTMLperson5
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.