Copy data work in database (oracle, teradata)

[mansour_ib_sas]

Hello,

Can we copy a table work  to a database (oracle, teradata ..) ?

thank you

[RW9]

Yes.

[LinusH]

Do you mean that you have one or more data sets in SASWORK (WORK) libfref, and want to copy them?

Of course you can. It will help if you have the license for SAS/ACCESS to Teradata end Oracle respectively (or even ODBC). If you don't, you probably need to do it in a more manual way via an external file, and load it using RDBMS tools.

[mansour_ib_sas]

Thank you for your answer which is very clear.

However, before copying a work table into a sgbdr system, do I have to inform a dba for example.

Or it's just a storage space like the folders we create in our Windows directories.

[LinusH]

You always need authorization for data operations, like create table and insert into.
If you are unsure of what authorization you have, yes, talking to your DBA's is a natural step.

[mansour_ib_sas]

If I want to put a table work in a sgbd in a temperate way;

the time of a treatment.

At this point, should I inform the dba?

[andreas_lds · Accepted solution]

---

@mansour_ib_sas wrote:

If I want to put a table work in a sgbd in a temperate way;

the time of a treatment.

At this point, should I inform the dba?

---

Talk to you dba-staff ... we don't know the rules your company has.