Oracle commands create user, authorization, database import, export

Recently in the use of Oracle, often to import export data, commands are simple, but often forget, so write down.

Drop UserYfplssCascade;--log on to the system user to delete the existing user name and everything under that user is deleted.--CREATE TABLE SpaceCreatetablespace YFPLSS loggingdatafile'd:/app/administrator/oradata/oral/yfplss.dbf'--address of the storage table spaceSize 100m--sizeAutoextend on --150M Auto GrowthNext150m maxsize 10240mextent management local;--Create userCreate UserYFPLSS identified byYfplssdefault--The first YFPLSS is the user name, and the second YFPLSS is the passwordTablespace YFPLSSTemporaryTablespaceTemp;--The default table space is YFPLSS--Assigning permissions to usersGrantConnect,resource,dba toYFPLSS;Commit;--Import Data:Imp YFPLSS/Yfplss@orcl file=D:\mydata.dmp Fromuser=YFPLSS Touser=YFPLSS grants=No;--YFPLSS/YFPLSS is the username/password @orcl server database name, file=d:\mydata.dmp the data storage path for the import--Data export:ExpYfplss/Yfplss@orcl  file=D:/Oms.dmp

Oracle commands create user, authorization, database import, export