2) as required_size_gb -> from dba_ob_tenants t,cdb_ob_table_locations t1,cdb_ob_tablet_replicas t2 -> where t.tenant_id=t1.tenant_id -> and t1.svr_ip=t2.svr_ip -> and t1.tenant_id=t2.tenant_id -> and t1.ls_id=t2.ls_id -> and t1...
[root@10-186-58-75 ~]# mysql -h10.186.58.75 -P8001 -uroot -proot -f < 1.sql ERROR 1046 (3D000) at line 1: No database selected ERROR 1049 (42000) at line 4: Unknown database 'renzy' [root@10-186-58-75 ~]# echo $? 0 临时修复 进入OMS 容器,按 OMS 容器初始化脚本提示(下...
ERROR 1046 (3D000 ) : No database selected ERROR 1047 (HY001) : Unknown packet ERROR 1048 (23000) : Column '%.*s' cannot be null ERROR 1049 (42000) : Unknown database '%.*s' ERROR 1050 (42S01) : Table '%.*s' already exists ERROR 1051 (42S02) : Unknown table '%.*s' ERR...
MySQL [(none)]> CREATE TABLE t1 (id int,name varchar(20)); ERROR 1046 (3D000): No database selected MySQL [(none)]> use testdb Database changed MySQL [testdb]> CREATE TABLE t1 (id int,name varchar(20)); Query OK, 0 rows affected (0.058 sec) MySQL [testdb]> insert into t1(...
obclient> SHOW RECYCLEBIN; Empty set (0.01 sec) obclient> CREATE TABLE test1 AS SELECT * FROM t1; ERROR 1046 (3D000): No database selected obclient> USE test; Database changed obclient> CREATE TABLE test1 AS SELECT * FROM t1;
Connect to OceanBase Database by using a Druid connection pool (Oracle mode) Prerequisites You have installed OceanBase Database and created an Oracle tenant. You have installed Java Development Kit (JDK) 1.8 and Maven. You have installed Eclipse. ...
```shell SQL> select * from t1; no rows selected ``` 执行如下存储过程。 ```shell SQL> declare fee1 date; fee2 number(14, 2); begin select min(c1) into fee1 from t1; insert into t2 values(fee1 - to_date('2020-01-01', 'yyyy-mm-dd')); commit; end; / PL/SQL procedure ...
CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] database_nameQueries the CREATE DATABASE statement. TheIF NOT EXISTSkeyword is used to addIF NOT EXISTSto the create statement. CREATE TABLE table_nameQueries the CREATE TABLE statement. CREATE VIEW view_nameQueries the CREATE VIEW statement. ...
If you selectedFull MigrationandIncremental Synchronizationwhen you created the data migration task, the data transmission service requires that the local incremental logs of the source database be retained for at least 7 days. If the data transmission service cannot obtain increme...
Fixed an issue where regular users received "no permission" errors when viewing task details after tasks were assigned a risk level. Fixed an issue where the "Specify Partition" option was not selected when re-initiating data archiving tasks based on the specified partition. ...