Home > Blockchain >  I want to move one table from SQL developer on computer A to SQL developer on computer B
I want to move one table from SQL developer on computer A to SQL developer on computer B

Time:03-31

I'm trying to move a table from a database on SQL Developer on my laptop to my desktop's SQL developer

enter image description here

The files to generate the tables and the schema I no longer have access to so I feel like this is my only option. But I can't figure out how to do this smoothly, is it even possible? I'm also open to just recreating the table

It should be simple but I can't figure it out. I'm a complete beginner so I suspect this has something to do with having the table connecting to the other tables in the model which is why this can't be done easily or requires more steps than I'm think it'll take.

Here are the tables details.. enter image description here

enter image description here

enter image description here

CodePudding user response:

SQL Developer is NOT a database.

SQL Developer is a client application that is used to access one or more databases.

There are many options including:

  • Backup your database and then copy the backup and restore it on the laptop.
  • In SQL Developer, use "Tools" then "Database Export".
  • Run SELECT DBMS_METADATA.GET_DDL('TABLE', TABLE_NAME) FROM USER_TABLES; and copy the generated DDL statements to the laptop and generate the tables.
  • Right-click on an individual table in SQL Developer and generate the DDL for the table and save it to a file and then run the DDL statement on the laptop.
  • Related