Exforsys
+ Reply to Thread
Results 1 to 2 of 2

tablespace management

This is a discussion on tablespace management within the Oracle Database forums, part of the Database category; when I am importing one users schema(A) into anothers schema(B), all the imported objects are in the tablespace of exported ...

  1. #1
    srilata is offline Junior Member Array
    Join Date
    Jul 2007
    Answers
    6

    tablespace management

    when I am importing one users schema(A) into anothers schema(B),
    all the imported objects are in the tablespace of exported user(A) even when
    I am mentioned other default tablespace for that user.
    I want the imported objects to be in default tablespace of his own(B).
    for that what I have to do.
    Please answer for this question.


  2. #2
    Larry Cumber is offline Junior Member Array
    Join Date
    Jul 2007
    Location
    Birmingham-UK
    Answers
    12
    Are you importing one user's schemal objects into another's as a DBA?
    Well,try this, Make sure both users do not have the DBA-role. then log in as one user and use the from user to user option and set the default tablespace.


Latest Article

Network Security Risk Assessment and Measurement

Read More...