|
-
Hello Stecal,
Thanks for reply.
yes. my scott user have dba granted to him.. I did not understand exactly about session you said .. but I was able to export using following command
C:\>exp USERID=scott/tiger@mytestdb file=c:/latest.dmp full=y;
I think problem was because of 2 databases I have 1 is mytestdb and other is db1 and when I tried with previous command it might be taking scott user of db1 and not of mytestdb.. and I think by session you mean to say with which database I was connected. may be I am wrong.
Regarding old export .. it seems to work fine using 11g also. yes you are right that it is old version but.. I used what I find first during my google search.. though I am learning things during my project progress.
Again thanks for your reply. May be I did not ask question as much perfectly as it should be.
But I found the solution using @serviceid in export command.
Thanks.
Amar4kintu
Tags for this Thread
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
|