S
S
Smilley2017-05-11 13:12:49
Oracle
Smilley, 2017-05-11 13:12:49

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

4 answer(s)
A
Andrew, 2017-05-11
@Dronablo

SELECT DBMS_METADATA.GET_DDL('TABLE','ИМЯ ТАБЛИЦЫ','ИМЯ ВЛАДЕЛЬЦА ТАБЛИЦЫ') FROM DUAL;

M
Max, 2017-05-11
@MaxDukov

Describe

P
protven, 2017-05-11
@protven

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.

M
Maxim Y, 2017-05-11
@x_shader

What kind of software is there?
You can export to a file, if suddenly only the Oracle client is installed:
Or as Andrew wrote above.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question