Import and Export exp and imp commands from oracle

Oracle Import and Export exp, imp command Database Export 1. Export the database completely exp username/password @ test file = d:/xxx. dmp full = y2. export only the user's table exp username/password @ test file = d:/export. dmp owner = (xxx, xxx) 3. export the table in the database exp username/password @ test file = d:/export. dmp tables = (table1, table2, tables3) 4. export a field in a table in the database according to the condition exp username/password @ test file = d:/export. dmp tables = (tables) query/"where filed like00 %/" data import to database 1. data in dmp is imported to the test database imp usernmae/password @ test file = xxx. dmp (ignore = y) if the table already exists, an error is returned, ignore will not be added. 2. Import the file data to a database table table1imp username/pwd @ test file = xxx. the dmp tables = (table1) operation must have sufficient permissions. Otherwise, the system will prompt the database, tnsping test 4, to check whether the database can be connected.