Disclaimer: This article is for bloggers in the project to use some of the common commands, do not reprint.
Oracle Common Naming Summary
To create a table space:
--create tablespace VMS
--datafile ' e:\vms.dbf '
--size 32000M
--extent Management local uniform size 100M;
Drop User C # #vms;
Create User C # #vms identified by vms2014
Default Tablespace VMS;
Delete Table space
DROP tablespace tablespacename including CONTENTS and datafiles CASCADE CONSTRAINTS;
Grant all privileges to C # #vms;
Authorized
Grant DBA to C # #vms;
Alter User C # #vms quota unlimited on VMS;
Import
Imp C # #vms/[email protected]/oracle file=e:\bknew\daochu.dmp tables=s_country grants=n Fromuser=vms touser=c# #vms buffer=100000000
Imp mes/[email protected] file=e:\db\oracle.dmp ignore=y tables= (Ecua2lfilever,ecuversion,ecudcmfile,ecuewpfile, Ecufileinfo,ecuimage,ecumodelreference,ecutestreport) full=n
At the time of import:
Constraints=n Do not import constraints
Imp_tian.par
Userid=system/password
File = Exp_tian.dmp
Fromuser=sasman
Touser=oraver02
buffer=20000000
Ignore=y
Grants=n
Constraints=n
Rows=y
Log=imp_tian.log
Commit=y
Nohup imp parfile=imp_tian.par 2>imp_tian.out 1>&2 &
Very simple, check the dba_tablespaces data dictionary:
Select Tablespace_name from Dba_tablespaces;
·· If a service does not start.
ALTER DATABASE datafile ' file_name ' offline drop
This file_name you to change to the file path plus the filename you deleted.
Ask
Did it succeed or did you see the other table space?
Reply
Successful execution you have to open the database ah;
ALTER DATABASE open;
EXP sonic/sonic buffer=64000 file=c:\sonic. DMP owner=sonic tables= (SONIC)
This way the user Sonic table Sonic is exported
To delete a tablespace with data
Alter TABLESPACE VMS offline
Drop tablespace VMS including contents;
Set up a table space for auto-growth
Autoextend on next 1000M maxsize umlimited extent management local segment space management auto;
Create Tablespace "Jydb" Logging datafile ' d:\oracle\oradata\JYDB.dbf ' size 5000M autoextend on next 1000M maxsize unlimit Ed Extent management local segment space management auto;
C:\users\administrator>imp ctbt/[email PROTECTED]/ORCL file=e:\imp\daochu.dmp Fromuser=vms TOUSER=CTBT Constraints=n ignore=y buffer=819200;
For example: IMP scott/tiger ignore=y tables= (emp,dept) full=n
Oracle Common Naming Summary