Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Total estimation using BLOCKS method: 64 KB Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Starting "MDP"."SYS_EXPORT_SCHEMA_01": directory=my_dir dumpfile=mdp.dmp logfile=mdp_exp.log reuse_dumpfiles=trueĮstimate in progress using BLOCKS method. Legacy Mode has set reuse_dumpfiles=true parameter. Legacy Mode Parameter: "log=mdp_exp.log" Location: Command Line, Replaced with: "logfile=mdp_exp.log" Legacy Mode Parameter: "file=mdp.dmp" Location: Command Line, Replaced with: "dumpfile=mdp.dmp" Legacy Mode Active due to the following parameters: All rights reserved.Ĭonnected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production OK, operating system level, command prompt: export the user: C:\>expdp directory=my_dir file=mdp.dmp log=mdp_exp.logĮxport: Release 11.2.0.2.0 - Production on Ned Vel 3 18:00:54 2019Ĭopyright (c) 1982, 2009, Oracle and/or its affiliates. SQL> create view v_test as select * From test SQL> grant read, write on directory my_dir to mdp Īs MDP (it is user I created while answering your other question, here: What are roles and privileges to give a user in order to perform CRUD(on Oracle 12)), create some objects: SQL> connect create table test (id number) SQL> create directory my_dir as 'c:\temp' Grant required privileges on it to user which will be using it. Here's an example.įirst, as SYS, create a directory (Oracle object) which points to directory (folder) on my hard disk drive. I wouldn't do it with TOAD, but from command prompt, using Data Pump Export and Import on command prompt.
0 kommentar(er)
