Oracle Import and Export Exp/imp

---------------Export
$exp ywpt/[email protected]File=d:\ywpt20140407.dmp log=d:\test.log owner= (YWPT);
$exp yboltp/[email protected]_10.248.24.152 file=d:\ywpt20140407.dmp log=d:\test.log TABLES = '%bk_20140% ';
---------------Import
$imp ywgl/[email protected]File=d:\ywpt20140407.dmp log=d:\test.log full= y;


-----Delete a user
Drop user YWPT cascade;
-----Rebuilding users
CREATE USER YWPT identified by ywpt2014
DEFAULT tablespace YWPT
Temporary tablespace TEMP;

GRANT
Create SESSION, create any TABLE, create any VIEW, create any INDEX, create any PROCEDURE,
Alter any TABLE, alter any PROCEDURE,
Drop any TABLE, drop no VIEW, drop any INDEX, drop any PROCEDURE,
SELECT any table, INSERT any table, UPDATE all table, DELETE any table
to YWPT;

Grant Connect,dba,resource to YWPT;

Grant SELECT on V_$statname to YWPT;
Grant SELECT on V_$sesstat to YWPT;
Grant SELECT on V_$session to YWPT;
Grant SELECT on V_$mystat to YWPT;

Grant CREATE procedure to YWPT;

-----Change Password
Alter user YWPT identified by YWPT;





C:\users\long>exp help=y

Export:release 10.2.0.3.0-production on Wednesday April 2 11:15:31 2014

Copyright (c) 1982, 2005, Oracle. All rights reserved.



Export by entering the EXP command and your username/password
The action prompts you to enter the parameters:

For example: EXP Scott/tiger

Alternatively, you can control the export by entering an EXP command with various parameters
The operating mode. To specify parameters, you can use keywords:

Format: EXP keyword=value or keyword= (value1,value2,..., Valuen)
For example: EXP scott/tiger grants=y tables= (emp,dept,mgr)
or tables= (T1:P1,T1:P2), if T1 is a partitioned table

The USERID must be the first parameter in the command line.

Keyword description (default) keyword description (default value)
--------------------------------------------------------------------------
USERID username/password Full export entire file (N)
Buffer Data buffer size owner owner user Name list
File output files (expdat. DMP) List of TABLES table names
COMPRESS Import to a zone (Y) RecordLength IO record length
GRANTS Export Permission (Y) Inctype Incremental Export type
INDEXES Export Index (y) RECORD tracking incremental export (Y)
Direct path (N) TRIGGERS export Trigger (Y)
Log screen output STATISTICS Analysis Object (ESTIMATE)
Rows Export data row (Y) parfile parameter file name
Consistent cross-table consistency (N) CONSTRAINTS export Constraints (Y)

Object_consistent only transactions that are set to read-only during object export (N)
FEEDBACK Show progress per x line (0)
FILESIZE maximum size per dump file
FLASHBACK_SCN used to set the session snapshot back to the previous state of the SCN
Flashback_time the time to get the SCN closest to the specified time
QUERY The SELECT clause that is used to export a subset of tables
Resumable hangs when encountering a space-related error (N)
Resumable_name text string used to identify a recoverable statement
Resumable_timeout resumable Waiting time
Tts_full_check performing a full or partial correlation check on TTS
tablespaces List of table spaces to export
Transport_tablespace exporting the Transportable tablespace metadata (N)
Template call IAS schema exported templates name

Oracle Import and Export Exp/imp