CODEWITHSUNDEEP
oracle-databaseoracle-apex
Андрій Гавриляк
Андрій Гавриляк

Reputation: 125

Transferring the project to another server, with all the data in apex oracl

I want to migrate the project to another server, I exported the project, and generated for all the tables. But I can't migrate these tables. Someone can help me with this. ????

Upvotes: 0

Views: 153

Answers (1)

Dan McGhan
Dan McGhan

Reputation: 4659

Based on your description, I'd say your best bet to migrate any custom schemas is to use Data Pump. Data Pump is made up of three distinct components. They are the command-line clients, expdp and impdp; the DBMS_DATAPUMP PL/SQL package (also known as the Data Pump API); and the DBMS_METADATA PL/SQL package (also known as the Metadata API).

An example export would look like:

expdp hr TABLES=employees DUMPFILE=employees.dmp

That would generate a file you could move to the destination database (where a database directory can map to).

Then an example import would look like:

impdp hr DIRECTORY=dpump_dir1 DUMPFILE=employees.dmp TABLES=employees

Of course, there are many more options than that. Here's the official doc: https://docs.oracle.com/en/database/oracle/oracle-database/18/sutil/index.html

Also, if you want to move to Oracle's new always free tier, then Adrian Png provides a nice overview that also touches on some APEX related topics here: https://fuzziebrain.com/content/id/1920/

Upvotes: 2

Related Questions