Oracle Delete Table times error: Table or view does not exist ____oracle

Source: Internet
Author: User
Tags oracle database

Indicates that it exists, but it complains when it is deleted: The table or view does not exist.
One possible reason is that the table name contains lowercase and can be removed by using the drop command with double quotes containing the table name.
As shown below:

drop TABLE "Employee"

One, what is the Oracle character set

An Oracle character set is a collection of symbols that are interpreted as a byte of data, having a size and a mutual containment relationship. ORACLE's support for the national language architecture allows you to use localized languages to store, process, and retrieve data. It makes database Tools, error messages, sort orders, dates, times, currencies, numbers, and calendars automatically adapted to localized languages and platforms.

The most important parameter that affects the Oracle database character set is the Nls_lang parameter.

Its format is as follows: Nls_lang = Language_territory.charset

It has three components (language, region, and character set), and each component controls the characteristics of the NLS subset.

which

Language: Specifies the language of the server message, which indicates whether the message is Chinese or English

Territory: Specifies the date and number format of the server.

Charset: Specifies the character set.

such as: American _ AMERICA. Zhs16gbk

From the composition of Nls_lang we can see that the real impact of the database character set is actually the third part.

So the character set between the two databases as long as the third part of the same can be imported to export data, before the impact of only the hint information is Chinese or English.

How to view the database version

SELECT * FROM V$version

BANNER
1 Oracle Database 11g Enterprise Edition release 11.1.0.7.0-64bit Production
2 Pl/sql Release 11.1.0.7.0-production
3 CORE 11.1.0.7.0 Production
4 TNS for Linux:version 11.1.0.7.0-production
5 Nlsrtl Version 11.1.0.7.0-production

Contains version information, core version information, bit information (32-bit or 64-bit) as for the bit information, on the Linux/unix platform, you can view it through file, such as file $ORACLE _home/bin/oracle

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.