Oracle Common Naming Summary

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.