-
Copy tables from schema to CD
Hi friends,
If i want to copy all my tables from one schema to a CD or to another drive.
Tell what is the way?
Question asked by visitor Ram
-
Expert Member
Re: Copy tables from schema to CD
Run -->cmd type the following command
exp scott/tiger owner=scott file=c:\scott.dmp log=c:\s.log(for server system)
or
exp80 scott/tiger@orcl owner=scott file=c:\scott.dmp log=c:\s.log
And copy the scott.dmp file in required CD or any drive
-
Re: Copy tables from schema to CD
You need to use the Export utility to create a crash dump file and copy to CD .From the File you can recreate all the objects in the schema.
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