Is this the right way to import an Oracle dump database?

I need to import Oracle Database from production to development for just one schema. What is the easiest way to do this? I did this to remove the user using this scheme and recreate the user with the same parameters and run the import command. Is it correct?

I am using Oracle 10g and I am not a DBA developer, but my DBA gives me a dump file and I need to create a local test environment.

Do I need to abandon the user? Can I just delete all objects for this user?

+3
source share
4 answers

, RMAN ? , Oracle, impdp, . : http://www.orafaq.com/wiki/Datapump

, RMAN.

+2

, .

, , .

?

, . .

+2

, , import\export.

Oracle Data Pump , Oracle .

Data Pump , Oracle " " .

+1

imp userName/password@Schema file=Path full=y

userName= oracle
password=
Schema=
Path= c:\dumpfile.dmp

0

Source: https://habr.com/ru/post/1763880/


All Articles