The project needs to use Dameng DTS, Just install it

1. install

Just install it directly according to the official documents

Database installation | Damon technical documentation

Configure the instance | Damon technical documentation

Registration service | Damon technical documentation

Start and stop the database | Damon technical documentation

After installation, the environment variable only needs to be added :

export PATH=$PATH:$DM_HOME/bin:$DM_HOME/tool

Connect directly after installation and startup ( Suggest window Lower connection , convenient )

Default account and password

SYSDBA:SYSDBA

2. And then create the user , Create tablespace And associate users with tablespaces

Refer to the official

Create tablespace | Damon technical documentation

Pay attention to the concept of users and patterns

Relationship between users and patterns | Damon technical documentation

3. Create table

Create database objects | Damon technical documentation

I didn't follow the official , The directly created table is called t_test

I use it directly select * from t_test The query keeps reporting errors

An error is as follows :

-2106: The first 1 An error occurred near the line :
Invalid table or view name [T_TEST]

Check for many times and find no problem

There's really no way out , According to the official creation ( Modify the schema name for what you created )

CREATE TABLE test.city
(
 city_id CHAR(3) NOT NULL,
 city_name VARCHAR(40) NULL,
 region_id INT NULL
);

Then execute the query

SELECT *  from city

No longer an error

Compare the tables you created , Table name has "_", Just add "" try , Sure enough , It seems that this is the problem

ha-ha , Do not follow the document , Delay time , But it is also a lesson learned , This problem will come up sooner or later