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?
[b]Question asked by visitor Ram[/b]
Printable View
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?
[b]Question asked by visitor Ram[/b]
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
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.