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.