oracle nosql db

First, Create database linkCreate Public Database Link to_xxx Connect to userobj using' (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = XX). Xx. Xx. XX) (port= 1526)) (Connect_data = (SERVER = dedicated) (service_name =xx)) ';Description Userobj is a user Second, Create the userCreate User Userobj identified by "" defaulttablespace XX passwordexpire--Grant/revoke System privilegesthird, the use of DblinkSELECT * FROM [email protected] to_xxx ;

(c.defer,32), +, ' RELY ', null), C.mtime, Decode (c.type#, 2, U I.name, 3, ui.name, NULL), Decode (c.type#, 2, Oi.name, 3, oi.name, NULL), Decode (Bitand (C.defer, 256), 256, Decode (c.type#, 4, Case when (Bitand (c.defer,) = or O.status in (3, 5) or Ro.status in (3, 5) and then ' INVALID ' else nul L End, case when (Bitand (C.defer, m) = O.status in (3, 5)) the N ' INVALID ' else null end), NULL), Decode (Bitand (C.defer, (), "DEPEND on VIEW", null) from sys.con$ OC, sys.con$ RC,

=yIMP hr/123456 buffer=64000 file=hr.dmp fromuser=hr touser=hrIMP hr/123456 buffer=64000 file=hr-xue.dmp tables=xue ignore=y Only several modes of export were tested, and the imported table mode, user mode. The other import did not succeed. If the table structure exists, IMP should add ignore=y, ignoring the error. or directly delete the table data and table structure, with drop without delete. Delete and change the related rows or tables, and then use the backup data for recovery.Sqlplus hr/12