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

This article mainly explains how to delete the Object table and recycle bin. Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let Xiaobian take you to learn "how to delete the Object table and recycle bin"!

I. Synonyms

Oracle synonyms literally mean aliases and function like attempts, a mapping relationship.

create

create public synonym table_name for user.table_name;

undefined

delete

drop public synonym table_name;

II. Deletion of Tables & Recycle Bin

Delete object to Recycle Bin

drop table table_name;

completely delete

DROP TABLE table_name PURGE;

Delete tables in Recycle Bin

purge table [schema.] table[,[ schema.] table ]...

Flashback deleted tables

FLASHBACK TABLE[schema.] table[,[ schema.] table ]...

TO { TIMESTAMP | SCN } expr

[ { ENABLE | DISABLE } TRIGGERS ];

example sentences

DROP TABLE emp2;

SELECT original_name, operation, droptime FROM recyclebin;

FLASHBACK TABLE emp2 TO BEFORE DROP;

III. Contents

Create & modify directory statements

CREATE OR REPLACE DIRECTORY directory_name AS '';

Grant permission to a user

GRANT READ ON DIRECTORY directory_name TO user_name;

delete directory statement

DROP DIRECTORY directory_name;

IV. External tables

syntax

CREATE TABLE ( , … )

ORGANIZATION EXTERNAL

(TYPE

DEFAULT DIRECTORY

ACCESS PARAMETERS

(… ) )

LOCATION ('') ) REJECT LIMIT [0 | | UNLIMITED];

undefined

example sentences

CREATE TABLE oldemp(

fname char(25),

lname CHAR(25))

ORGANIZATION EXTERNAL(

TYPE ORACLE_LOADER

DEFAULT DIRECTORY emp_dir

ACCESS PARAMETERS(

RECORDS DELIMITED BY NEWLINE

NOBADFILE

NOLOGFILE

FIELDS TERMINATED BY ','(

fname POSITION ( 1:20) CHAR,

lname POSITION (22:41) CHAR))

LOCATION ('emp.dat'))

PARALLEL 5

REJECT LIMIT 200;

At this point, I believe that everyone has a deeper understanding of "how to delete the Object table and recycle bin", so let's actually operate it! Here is the website, more related content can enter the relevant channels for inquiry, pay attention to 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.