Oracle exports imports with Exp\imp, and creates tablespace and user ____oracle

Oracle EXP Export Table structure:
Exp username/pwd@sid file=d:\db1.dmp owner= (username) rows=n;
The above command, removing the rows=n parameter, will also export all the table data.
Parameter description
Keyword description (default) keyword description (default)
--------------------------------------------------------------------------
USERID username/password Full export entire file (N)
Buffer Data buffer size owner owner user Name list
File output files (expdat. DMP) Tables Table Name list
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 directly path (N) triggers export trigger (Y)
Log screen output logs file STATISTICS Analysis Object (estimate)
Rows Export data row (Y) parfile parameter file name
Consistent cross-table consistency CONSTRAINTS export constraint (Y)


FEEDBACK Show progress per x line (0)
FILESIZE the maximum size of each dump file
FLASHBACK_SCN the SCN used to callback session snapshots
Flashback_time is used to get the SCN time closest to the specified time
Select clause used by QUERY to export a subset of a table
Resumable hangs (N) when it encounters a space-related error
Resumable_name a text string used to identify recoverable statements
Resumable_timeout Resumable's Waiting time
Tts_full_check perform a full or partial dependency check on TTS
tablespaces List of table spaces to export
Transport_tablespace export of removable tablespace metadata (N)
TEMPLATE calling the template name exported in IAS mode


The following comes with creating a tablespace and creating a User:
--Create a Armyoa table space
Create Tablespace Testoa
Logging DataFile ' D:\oracle\oradata\orcl\testoa. DBF '
Size 32M autoextend on next 32M Maxsize 20480M extent management local;




--Create ARMYOA temporary table space
Create temporary tablespace testoa_temp
Tempfile ' D:\oracle\oradata\orcl\testoa_temp. DBF '
Size 32M autoextend on next 32M Maxsize 20480M extent management local;


Create User Testoa
Identified by Testoa
Default Tablespace Testoa
Temporary tablespace testoa_temp;


--Grant/revoke role privileges
Grant DBA to Testoa;

Oracle IMP Import:
Imp username/pwd@sid file=d:\db1.dmp ignore=y full=y
Parameter description:
Keyword description (default) keyword description (default)
--------------------------------------------------------------------------
USERID username/password Full import entire file (N)
Buffer Data buffer size Fromuser list of all user names
File input files (expdat. DMP) touser List of user names
Show list only the contents of the file (N) table List of tables
IGNORE Ignore creation error (N) RecordLength IO record length
Grants Import permission (Y) Inctype incremental import type
INDEXES Import Index (Y) commit array Insert (N)
Rows Import data row (Y) parfile parameter file name
Log screen output CONSTRAINTS import restrictions (Y)
DESTROY Coverage Table space data file (N)
Indexfile writes table/index information to the specified file
Skip_unusable_indexes Skip maintenance for index not available (N)
FEEDBACK Show progress per x line (0)
Toid_novalidate to skip validation of the specified type ID
FILESIZE the maximum size of each dump file
STATISTICS always import the estimated statistical information
Resumable hangs (N) when it encounters a space-related error
Resumable_name a text string used to identify recoverable statements
Resumable_timeout Resumable's Waiting time
COMPILE compilation process, package and function (Y)


The following keywords are only available for use in a table space that can be transferred
Transport_tablespace import of removable tablespace metadata (N)
Tablespaces The table space to be transferred to the database
Datafiles data files to be transferred to the database
Tts_owners a user with data in a table-space-centralized transport