Results 1 to 3 of 3

Thread: Copy tables from schema to CD

  1. #1
    Geek_Guest
    Guest

    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


  2. #2
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    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


  3. #3
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    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
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact