In cases where the owner of the table cannot be changed, you can use the method of importing and exporting the table structure and table data to move the table under the owner you want (note: In particular, if you are logged in as a sysdba, the owner of all tables is SYS, which can cause trouble for you to access the database in C #, In my other article, I also mentioned ". NET connection to Oracle database errors, myobjects filter in PL/SQL), you can only change the owner in this way. Export Table structure: tools (tool)-->export user Objects (Export users object)--select-->.sql file to export (including sequence, etc.), export table data for SQL file: Tools -->export Tables (export table)--Select table, select SQL Inserts (SQL Insert)-->.sql file import table structure: Execute the SQL file you just exported, and remember to delete the user name before the table. For example, before this table is named Sys.tablename, you must delete the SYS import table data: Execute the SQL file you just exported
PL/SQL Developer import, export table structure and table data
