I'm trying to move a table from a database on SQL Developer on my laptop to my desktop's SQL developer
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.
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.