|
-
Hi,
There are 2 ways in which you can move objects from one user to another user.
Method 1:
If you are using Oracle 8i and above use the follwoing command to move the table from one tablespace to another tablespace:
sql> alter table emp
move tablespace TBS2;
Method 2:
1) Take the export of the table by the following command
exp sys file=emp.dmp log=a.log rows=y indexes=y grants=n consistent=y statistics=none
2) Import the dump file but without the data and index by the following command:
imp sys file=emp.dmp log=b.log rows=n indexes=n grants=n commit=y ignore=y fromuser=user1 touser=user2
indexfile=crt.sql
3) Edit the indexfile and change the tablespace name from tbs1 to tbs2 and run the script.
4)Again import the dump file with the follwoing command
imp sys file=emp.dmp log=b.log rows=y indexes=y grants=y commit=y ignore=y fromuser=user1 touser=user2
In case of any help please be free to ask me at [email protected]
Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
[email protected]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|