CODEWITHSUNDEEP
oracle-databaseoracle11g
kinkajou
kinkajou

Reputation: 3728

Creating table in other schema oracle using select

How do I create table in different schema of local database using linked database ?

create table schema1.table1 select * from  schema.table@LinkedDB;

Upvotes: 2

Views: 14008

Answers (1)

OMG Ponies
OMG Ponies

Reputation: 332731

You were close - use:

CREATE TABLE schema1.table1 AS (SELECT * FROM SCHEMA.table@LinkedDB);

You can read more about it here.

Upvotes: 4

Related Questions