This should work with oracle 8 and +<\/p>\n
The consistent=yes parameter locks the Objects as read only to ensure data consistency.<\/p>\n
Depending on the environment settings the @oracle_sid parameter in the user name may be optional.<\/p>\n
exp User_name\/user_pass@oracle_sid FULL=y FILE=my_export_file.dmp LOG=my_export_log CONSISTENT=y<\/span><\/p>\n or<\/p>\n exp userid=User_name\/user_pass<\/span>@Oracle_sid<\/span> FULL=y FILE=my_export_file.dmp LOG=my_export_log CONSISTENT=y<\/span><\/p>\n to export schema from a user (owner_name)\u00a0 while logged as an admin (dba_name)<\/p>\n exp userid=dba_name\/dba_pass FULL=y FILE=my_export_file.dmp LOG=my_export_log CONSISTENT=y owner=owner_name This should work with oracle 8 and + The consistent=yes parameter locks the Objects as read only to ensure data consistency. Depending on the environment settings the @oracle_sid parameter in the user name may be optional. exp User_name\/user_pass@oracle_sid FULL=y FILE=my_export_file.dmp LOG=my_export_log CONSISTENT=y or exp userid=User_name\/user_pass@Oracle_sid FULL=y FILE=my_export_file.dmp LOG=my_export_log CONSISTENT=y to export schema from a user … Continue reading “Export oracle data”<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_newsletter_tier_id":0,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[1],"tags":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5WcEf-1x","_links":{"self":[{"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=\/wp\/v2\/posts\/95"}],"collection":[{"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=95"}],"version-history":[{"count":0,"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=\/wp\/v2\/posts\/95\/revisions"}],"wp:attachment":[{"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=95"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=95"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=95"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"