Answer the question
In order to leave comments, you need to log in
How to transfer Oracle database table structure between servers?
Good afternoon. There are three tables in one database, the structure of which I want to transfer to my Oracle Express server. Could you tell me, please, the easiest way to transfer? On the source server, the rights are very limited, and there is also no way to install any software.
Thanks in advance.
Answer the question
In order to leave comments, you need to log in
SELECT DBMS_METADATA.GET_DDL('TABLE','ИМЯ ТАБЛИЦЫ','ИМЯ ВЛАДЕЛЬЦА ТАБЛИЦЫ') FROM DUAL;
Install locally (is it even possible?) Oracle SqlDeveloper,
www.oracle.com/technetwork/developer-tools/sql-dev...
Setting up a connection to the schema from where to transfer data and where to transfer data.
Then Tools -> Database Copy and choose from where you copy and where you copy. If you need to copy only the structure, uncheck the "Copy Data" box.
Then select the tables you want to copy. All.
Well, or you can manually get a table creation script from the same Sqldeveloper. To do this, open the connection, go to "Tables", click on the table you need and select "SQL". All.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question