TNS is part of Oracle NET, dedicated to managing and configuring Oracle databases and client connections, and in most cases the client and the database must be configured with TNS, (you can use sqldeveloper without configuring TNS), so let's see how
Objn:object Name ID
Objd:object Data ID
OBJD will change depending on the turncate operation of the table
Sql> Select Object_id,object_name from user_objects where object_name= ' test_user '; object_id----------object_name-----------------------
There is a user's table to be imported into our system, the original table TM_WWM date is varchar (8) Type, the format is YYYYMMDD. Before importing to my system, we need to see if the date is legal SQL1 Select To_date (saledate, ' YYYYMMDD ')
I am based on the ubuntu11.10 version, and when the system is properly installed, follow these steps:
Introduction of how to install the enhanced features
1, choose the installation of Enhanced packaging package: The name of the package is
Oracle dmp file Import (restore) to different table spaces and different usersFirst, Exp/imp solution:1, can use SED to modify the DMP file, normal importSed-i ' s/test_ts/users/g ' a.dmp2. The DMP file contains information about the table space
[SCID news] Oracle has launched a program with AMD and sun to increase developers' support for their products.
The three companies announced on Thursday that they will invest $30 million in a joint plan for independent software developers in
After installing Oracle 10 Gb last time, I started to try to remotely use and manage Oracle, but the road was uneven. The following are the records about starting and using EM, sqlplus, and ISQLPLUS:
First, remotely log on to the Linux server
From: http://database.ctocio.com.cn/116/12198616.shtmlThe followingArticleThis article mainly introduces the advantages and disadvantages of Oracle Database indexes. If you want to know the advantages and disadvantages of Oracle Database indexes,
Use and Maintenance of Lob fields in Oracle
This document introduces the basic methods for using and maintaining the lob data type in Oracle databases through the dbms_lob package.
Keywords: Oracle dbms_lob lob Maintenance
Graph classification: TP31
Using shell scripts to monitor and manage Oracle databases will greatly simplify DBA workload, such as common instance monitoring, monitoring, and alarm log monitoring, and database backup, AWR report automatic mail, etc. This document describes how
It was freezing, and I stayed at home and read "Mastering Oracle SQL" 2nd. I found that Oracle is still very powerful, and there are two hundred optical functions. It is difficult to simulate the Object-Oriented Query languages, in particular,
[Oracle entry series] Chapter 2 _ Functions -- v512 studio Editor: Xuan Yu
Function
Nvl () function
Count () function
Case expression
My blog
Date type
Nvl2 () function
Dedode () function
Having clause
Flash back database operations in Oracle Database 10 GB
You can use flashback database to restore the database to a previous time point or an SCN number.In versions earlier than Oracle10g, to restore the database to a previous time point or SCN
Reprinted from: http://blog.csdn.net/atgc/article/details/2036799
Thanks to atgc, this problem has been studied for a day and finally solved !!
When extracting Chinese characters from the table, you need to consider character sets. Different
Three parts in total
Part 1 Oracle 10g Installation
Part 2 ORACLE Express Installation
Part 3 ora-12514 troubleshooting
Part 1 Oracle 10g Installation
Http://www.jb51.net/article/18038.htm
People who have just been familiar with Oracle will feel
From: http://dev.csdn.net/article/56/56449.shtm
T-SQL is the language engine of SQL Server, while Oracle's language engine is PLSQL. Both query languages have extended the ANSI SQL-92 standard to provide additional support. Almost all applications
Oracle 10g for Windows 10.1.0 [ISO]
[Security Detection passed] rising 17.57.42[Installation test] install Oracle Database 10 GB on WINXP SP2
If it cannot be opened, open the connection below copy of the new thunder task to start downloading.Address:
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