Shulou(Shulou.com)05/31 Report--

This article mainly explains "what are the ways to use ORACLE". Friends who are interested may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "what are the ways to use ORACLE?"

/ / Delete a user

Drop user lc0019999 cascade

/ / create a user

Create user lc0019999 identified by password

/ / Grant DBA permissions to users

Grant dba to lc0019999

/ / Import data

$imp lc0019999/password@server file=e:back312.dmp fromuser=lc0019999 touser=lc0019999

/ / Export data

$exp lc0019999/password@server file=e:backaaa.dmp

/ / change the sys and system passwords

Alter user system (sys) identified by newpassword

/ / change the archiving log method: archivelog and noarchivelog

Alter database archivelog (noarchivelog)

/ / the way of deframing honeycomb fragments

Alter tablespace tablespacename coalesce

/ / View default and temporary tablespaces

Select username from dba_users where default_tablespace='system' or temporary_tablespace='system' order by username

/ / change default and temporary tablespaces to non-system

Alter user rsingh default users temporary temp

/ / create tablespace command

Create tablespace tablespacename... (other command options)... extent management local uniform size 10m

/ / move indexes between different tablespaces

Alter index rebuild tablespace

/ / analyze the data tablespace (the execution result is not visible)

Analyze table compute statistics

/ / query the highest point of the table and the unused block of the table

Select blocks "high water mark", empty_blocks "unused space" from dba_tables where table_name='&table_name' and owner='&owner_name'

/ / release unused tablespaces

Alter table deallocate unused [keep [K | M]]

At this point, I believe you have a deeper understanding of "what is the use of ORACLE?" you might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.