current position：Home>Oracle database expdp only exports tables
Oracle database expdp only exports tables
2022-06-24 09:39:00【Huizhou wuyanzu】
EXPDP Do not import stored procedures , Just watch .
Method 1：– Direct inquiry dba_tables
nohup expdp ZLCHS/ZLCHS parfile=t1.par & Parameter file ： [[email protected] rmanbak]$ cat t1.par directory=expdp dumpfile=TEST_%U.dmp PARALLEL=2 logfile=1207-1.log include=table:"IN (select TABLE_NAME from dba_tables where OWNER='TEST')"
If you want to export part of the user name , You can set the table to the desired rule , Insert a temporary table such as temptable1
When exporting , Query the temporary table
include=table:"IN (select TABLE_NAME from temptable1)"
author[Huizhou wuyanzu],Please bring the original link to reprint, thank you.
The sidebar is recommended
- Unable to access the applet from the wechat official account on the PC
- Some questions about CSV file operation
- Notes to problems - Microsoft Visual c++ 14.0 or greater is required
- node_ Why is the module package getting bigger and bigger?
- A positive integer is called a number associated with 7 if it can be divided by 7 or if the number on a digit in its decimal representation is 7. Now we give a positive integer n (n < 1000) and judge whether it is a number related to 7
- How to convert numeric characters to decimal integers and output them?
- Shimadzu gc-2014c software is all in English. How to convert it into Chinese
- Two dimensional interpolation operation data in desktop TXT for 2D drawing
- Cruise is now charging for its driverless ride service in San Francisco
- Google warns that both apple and Android phones have been attacked by Italian Spyware
guess what you like
Windows 11 preview update for deeper onedrive consolidation
Google introduces 5 new features of Chrome browser for IOS
Ayaneo air, the world's first OLED windows lightweight handheld, opened crowdfunding and quickly exceeded HK $1million
The first M2 MacBook Pro arrives in New Zealand and Australia
Do me a favor. I don't understand this question
Springboot -- integrating druid and mybatisplus to realize SQL monitoring
Is that right? Solve
STM32 has two functions with one key without long and short press
Follow me to learn about Linux operation and maintenance
Springboot Foundation (17): hot deployment
- Springboot Foundation (18): third party bean attribute binding
- Springboot Foundation (19): loose binding
- Springboot Foundation (21): bean attribute verification
- Springboot Foundation (20): cuom
- Principles of vue3 compiler
- Reactiveeffect principle of vue3
- Patch update details for vue3
- Nexttick principle of vue3
- Advanced learning of Apollo autopilot: trafficdecker- > trafficlight- > stage_ approach
- Advanced learning of Apollo autopilot Part 1: how to manually control traffic light changes in the map
- Collection of interview questions for java development in 2022
- 2022java interview questions complete, with answers, latest arrangement
- [c++]: precautions when using new in constructor
- C++ 5 | composition and inheritance
- How to set a table to span pages and keep rows when generating a word file from a template
- What's wrong with this? Solve
- Pyqt5 how to make windows borderless and movable by dynamically loading the UI?
- How to add birth date C in a system++
- Revit secondary development stretching problem
- What's new in Xcode 14
- The birth of atomic quantum circuit marks a major breakthrough in quantum computer technology
- How to locate lock waiting in Dameng database
- Easily play with IOS 16 lock screen interface
- How to open an account online for new bonds? Please bless me
- React usestate storage function
- What else can the project implementation engineer do without the project?
- Precautions when applying to upgrade springcloud Version (Dalston to Edgware)
- A docker implemented by shell script
- Android studio simulator modify system language / enable Developer mode / customize resolution and size
- Android uses itemtouchhelper to realize item dragging position exchange and side sliding deletion of recyclerview
- Why does the menu bar created with QT in vs report errors
- Oauth2 released methods cannot be accessed
- About pyopengl: why is the obj model (dinosaur) read and displayed like this? How can it display the same material effect as the teapot
- CSS problem, card jitter
- Jpprofiler monitors the problem of excessive memory deployed under Tomcat
- A HashMap talked with the interviewer for half an hour
- Java interview experience in a small company
- I have made an application to visually generate echarts code, so I don't have to look at complex documents anymore (attached with project source code)
- Can you do it as soon as possible? There is not much time
- For non front and rear end separation projects, how can the front and rear ends be separated and packaged separately?