i want to create two migration repositery
the artical i am following has given me this command to create repositery user
CREATE USER MWREP
IDENTIFIED BY mwrep
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP;
GRANT CONNECT, RESOURCE, CREATE SESSION, CREATE VIEW TO MWREP;
1) Can i use any name for user or it is reserve user for migration repositery by oracle.
but i have tested creating more than one repositery by diffrent name , so i was in doubt and want to know about this user.
2) Please give me link where advance topics of migration is present, like about lob , binay etc.
Edited by: 944768 on Dec 15, 2012 11:51 PM
You can use any name as repository user - only make sure that you grant the correct permissions.
More details about migration can be found here: http://www.oracle.com/technetwork/database/migration/index-084442.html