sql - Copying tables from schema or database -
i use oracle database.
i confused concept between schema , database. looked around here , couldn't find explicit defined example.
suppose have qa, dev , production environment , suppose have 3 qa environments. between 3 qa environment, have different database or different schema?
suppose 3 different qa environments have different data in each environment. , suppose want create new fourth qa environment , want copy table (lets call table foo) 1 of existing qa environment (lets call environment qa_1) new qa environment (lets call qa_new). copying schema table foo qa_1 qa_new or copying database table qa_1 qa_new?
you want copy entire database new environment environments match.
a schema similar namespace. database can have multiple namespaces , you'll want copy all.
Comments
Post a Comment