General discussion

  • Creator
    Topic
  • #2175552

    Copying Database schema

    Locked

    by shaikahmadbasha ·

    How can we copy database table along with eniter schema from oracle to a non removale disk such that we can directly use it in another system (not in a network)by simply copying table in to
    oracle database of that system?

All Comments

  • Author
    Replies
    • #3335567

      Reply To: Copying Database schema

      by jaqui ·

      In reply to Copying Database schema

      db dump, with full inserts.

      add create statements options also.
      then you have an sql query with the structure and contents of the db, transfer that to the other machine and run the sql query on the new server.
      ( easier if both were connected, then do database replication between servers.

    • #3247481

      Reply To: Copying Database schema

      by asifnaveed11832 ·

      In reply to Copying Database schema

      You can do this by export/import command.
      Go Start menue and command Run “write exp” and in dos mode write system and its passward. press enter twice write file name in front of EXPDAT.DMP> like d:\abc.dmp a message appear 1(entire databas) 2(users) 3 (table)chose 1, 2 or 3 export grant y press enter, export table data y press enter,Compress extents y press enter write table or user name press enter
      then message appear user to be exported you can see this dump file abc.dmp on drive which you selected. and in import command do the same first message press n other all message press y do it hope fully you entire schema will copy on removale disk.

    • #3244088

      Reply To: Copying Database schema

      by asifnaveed11832 ·

      In reply to Copying Database schema

      Syntax for ‘EXP’ command with a query form the command line:
      Exp scott/tiger=h:\emp.dmp tables=dept,sal query =”””where empno = 7659″””

Viewing 2 reply threads