Georclau.comQ:
Import a part of database from one Oracle Database to another
I have two oracle databases, one is in an ASM file.
The second one is based on the first one.
Now I want to import the first database into the second database.
I have these 2 tables in the first database:
CREATE TABLE SIDEBAR (
SID VARCHAR2(10) NOT NULL,
SUBJECT_TITLE VARCHAR2(100) NOT NULL,
PRIMARY KEY (SID, SUBJECT_TITLE)
) ;
CREATE TABLE COURSE (
COURSE VARCHAR2(50) NOT NULL,
UNIT_CODE VARCHAR2(50) NOT NULL,
SUBJECT VARCHAR2(50) NOT NULL,
START_DATE DATE NOT NULL,
END_DATE DATE NOT NULL,
PRIMARY KEY (COURSE, UNIT_CODE, SUBJECT, START_DATE, END_DATE)
) ;
Now I want to import the SID, SUBJECT_TITLE, START_DATE, END_DATE and UNIT_CODE into the COURSE table from the SID, SUBJECT_TITLE, START_DATE, END_DATE, UNIT_CODE columns from the SIDEBAR table.
I have created some SQL scripts which import the SIDEBAR table in the first database into a Oracle table of the second database.
My question is, how can I create a SQL script which imports the COURSE table from the second database to the first one?
A:
Insert into COURSE (SID, SUBJECT_TITLE, START_DATE, END_DATE)
select SID, SUBJECT_TITLE, START_DATE, END_DATE
from SIDEBAR
All you need to do is list the column names and populate their data.
Generally, when a general purpose microprocessor is incorporated into a semiconductor device (e.g., a semiconductor memory), power is supplied from the microprocessor to the semiconductor device.
When a general purpose microprocessor is used, the microprocessor and the semiconductor device are interconnected by way of a system bus.
As will be described below, the ac619d1d87
Related links:
Comments